ORACLE uuid automatically generates a primary key

-- Create tablecreate table policycompany (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 64 K minextents 1 maxextents unlimited); -- Add comments to the table comment on table policycompany is 'Technology exchange company '; -- Add comments to the columns comment on column policycompany. FLOWID is 'application number'; comment on column policycompany. CONPANYID is 'competitor id'; comment on column policycompany. ISCOMMUNICATION is 'communication communication'; -- Create/Recreate primary, unique and foreign key constraints alter table policycompany add constraint sys_policycompany primary key (ID) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage (initial 64 K minextents 1 maxextents unlimited );