--Create Tablecreate table Technologycompany (ID VARCHAR2 (+) default sys_guid () not NULL, Flowid VARCHAR2 ( (), Conpanyid number, iscommunication VARCHAR2 (Ten)) tablespace USERS pctfree Initrans 1 Maxtrans 255 Storag E (initial 64K minextents 1 Maxextents Unlimited);--Add comments to the table comment on table technologycom Pany is ' Exchange company ';--Add comments to the columns comment on column technologycompany. Flowid is ' application number '; Comment on column technologycompany. Conpanyid is ' competitor ID '; Comment on column technologycompany. Iscommunication is ' communication ';--create/recreate primary, unique and FOREIGN KEY constraints alter TABLE Technologycompany a DD Constraint Sys_technologycompany primary KEY (ID) using index tablespace USERS pctfree Initrans 2 Maxtrans 255 Storage (initial 64K minextents 1 Maxextents Unlimited);
ORACLE UUID proactively generates primary keys