oracle 建立表

標籤：地址   number   drop   rowid   prim   time   tab   char   add   

--建立表

create table browser_track(btId number not null ,opend_id varchar2(50) not null,url_address varchar2(100) not null,params varchar2(50) null,stay_time number default 0 not null ,look_time number  default 0 not null ,behavior_name varchar2(10) not null,behavior_id number not null,pbehavior_name  varchar2(10) not null,pbehavior_id number not null,create_time timestamp not null,primary key (btId));--表注釋comment on table browser_track is ‘使用者行為跟蹤表‘;--欄位注釋comment on column browser_track.btId is ‘主鍵‘;comment on column browser_track.opend_id is ‘opend_id‘;comment on column browser_track.url_address is ‘url地址‘;comment on column browser_track.params is ‘參數列表‘;comment on column browser_track.stay_time is ‘停留時間‘;comment on column browser_track.look_time is ‘瀏覽時間‘;comment on column browser_track.behavior_id is ‘動作id‘;comment on column browser_track.behavior_name is ‘動作名稱‘;comment on column browser_track.pbehavior_name is ‘父動作名稱‘;comment on column browser_track.pbehavior_id is ‘父動作id‘;comment on column browser_track.create_time is ‘建立時間‘;--索引create index behavior_id on browser_track(behavior_id);select t.*,t.rowid from browser_track t;drop table browser_track;

 

oracle 建立表