oracle建表语句赋默认值

-- Create table
create table T_CUS_CUSTOMER
(
  ID	VARCHAR2(32) default SYS_GUID() not null,
  NAME	VARCHAR2(60) not null
)
tablespace USERS;
-- Create/Recreate primary, unique and foreign key constraints 
alter table T_CUS_CUSTOMER
  add constraint PK_T_CUS_CUSTOMER primary key (ID)
  using index 
  tablespace USERS;

版权声明:本文为shitongshuo原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。