CREATE TABLE "SCOTT"."SEATALLOTMENT" 
   (	"YEAR" NUMBER(4,0), 
	"COLLEGECODE" CHAR(4 BYTE), 
	"COURSECODE" CHAR(3 BYTE), 
	"REGISTRATIONNO" NUMBER(12,0) , 
	"ALLOCATEDTIME" TIMESTAMP (6) DEFAULT systimestamp );

CREATE TABLE "SCOTT"."COURSESEATS" 
   (	"YEAR" NUMBER(4,0), 
	"COLLEGECODE" CHAR(4 BYTE), 
	"COURSECODE" CHAR(3 BYTE), 
	"CATEGORYCODE" CHAR(2 BYTE), 
	"MAXINTAKE" NUMBER(4,0), 
	"AVAILABLE" NUMBER(4,0)
   ) 

Insert into COURSESEATS (YEAR,COLLEGECODE,COURSECODE,CATEGORYCODE,MAXINTAKE,AVAILABLE) 
values (2009,'krcl','CSE','OC',2009,60);
Insert into COURSESEATS (YEAR,COLLEGECODE,COURSECODE,CATEGORYCODE,MAXINTAKE,AVAILABLE) 
values (2009,'krcl','EEE','OC',2009,60);
Insert into COURSESEATS (YEAR,COLLEGECODE,COURSECODE,CATEGORYCODE,MAXINTAKE,AVAILABLE) 
values (2009,'krcl','ECE','OC',2009,60);

Insert into SEATALLOTMENT (YEAR,COLLEGECODE,COURSECODE,REGISTRATIONNO,ALLOCATEDTIME) 
values (2009,'krcl','CSE',101102103104,
to_timestamp('03-NOV-09 12.36.54.500000000 PM','DD-MON-RR HH.MI.SS.FF AM'));