ORACLE uuid自己主動產生主鍵

標籤：

-- Create tablecreate table TECHNOLOGYCOMPANY(  ID              VARCHAR2(32) default SYS_GUID() not null,  FLOWID          VARCHAR2(50),  CONPANYID       NUMBER,  ISCOMMUNICATION VARCHAR2(10))tablespace USERS  pctfree 10  initrans 1  maxtrans 255  storage  (    initial 64K    minextents 1    maxextents unlimited  );-- Add comments to the table comment on table TECHNOLOGYCOMPANY  is ‘技術交流的交流公司‘;-- Add comments to the columns comment on column TECHNOLOGYCOMPANY.FLOWID  is ‘申請編號‘;comment on column TECHNOLOGYCOMPANY.CONPANYID  is ‘競爭者ID‘;comment on column TECHNOLOGYCOMPANY.ISCOMMUNICATION  is ‘是否交流‘;-- Create/Recreate primary, unique and foreign key constraints alter table TECHNOLOGYCOMPANY  add constraint SYS_TECHNOLOGYCOMPANY primary key (ID)  using index   tablespace USERS  pctfree 10  initrans 2  maxtrans 255  storage  (    initial 64K    minextents 1    maxextents unlimited  );

ORACLE uuid自己主動產生主鍵