Oracle Database Build Table Jobs

--Create TableCreate TableSTUDENT (SnoVARCHAR2(3) not NULL, SnameVARCHAR2(8) not NULL, SsexVARCHAR2(2) not NULL, Sbirthday DATE, classVARCHAR2(5)) tablespace USERS PctfreeTenInitrans1Maxtrans255Storage (initial 64KNext1M minextents1Maxextents Unlimited);--Add comments to the tableComment on TableSTUDENT is 'Student Table';--Add Comments to the columnsComment on columnStudent.sno is 'study number (primary key)'; Comment on columnStudent.sname is 'Student Name'; Comment on columnStudent.ssex is 'Student Sex'; Comment on columnStudent.sbirthday is 'Student's date of birth'; Comment on columnStudent.class is 'students in the same class';

Oracle Database Build Table Jobs