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.