I'm trying to create a table in oracle here's the code
drop table class; create table class (schedule_num integer primary key not null, semester varchar(10), course_name varchar(14), credit int, department varchar(15), /* meeting_time time,*/ meeting_place varchar(20), enrollment_limit int);
I don't how to initiate the 'time' data-type, can someone help. The time is as in what time something starts. Example: the meeting starts at 9:00. I need to keyword and syntax.