Oracle CREATE TABLE

--Create a table

Create TableBrowser_track (Btid Number  not NULL, opend_idvarchar2( -) not NULL, Url_addressvarchar2( -) not NULL, paramsvarchar2( -)NULL, Stay_time Number default 0  not NULL, Look_time Number  default 0  not NULL, Behavior_namevarchar2(Ten) not NULL, behavior_id Number  not NULL, Pbehavior_namevarchar2(Ten) not NULL, pbehavior_id Number  not NULL, Create_timetimestamp  not NULL,Primary Key(Btid));--Table NotesComment on TableBrowser_track is 'User Behavior Tracking table';--Field CommentComment on columnBrowser_track.btid is 'PRIMARY Key'; Comment on columnbrowser_track.opend_id is 'opend_id'; Comment on columnBrowser_track.url_address is 'URL address'; Comment on columnBrowser_track.params is 'parameter list'; Comment on columnBrowser_track.stay_time is 'Dwell Time'; Comment on columnBrowser_track.look_time is 'Browse Time'; Comment on columnbrowser_track.behavior_id is 'Action ID'; Comment on columnBrowser_track.behavior_name is 'Action name'; Comment on columnBrowser_track.pbehavior_name is 'Parent Action Name'; Comment on columnbrowser_track.pbehavior_id is 'Parent Action ID'; Comment on columnBrowser_track.create_time is 'creation Time';--IndexCreate Indexbehavior_id onBrowser_track (behavior_id);SelectT.*, T.rowid fromBrowser_track t;Drop TableBrowser_track;

Oracle CREATE TABLE