查看Oracle约束

结论：复制检查约束和非空约束，但不会复制唯一约束和主键约束。

dba_constraints

col owner format a20
col table_name format a20
col constraint_name format a20
col constraint_type format a20
select table_name from tabs;
desc table_name
select table_name, owner, constraint_name, constraint_type from dba_constraints where table_name='&table_name';

• all_constraints

NOT NULL

实验1

实验2

实验3

R & P