如何查看user_constraints里的search_condiction

来源:互联网 发布:手机淘宝单怎么刷 编辑:程序博客网 时间:2024/05/27 00:29
QL> create global temporary table gtt_user_cons  2  (constraint_name    varchar2(30),  3   search_condition   clob);Table created.SQL> insert into gtt_user_Cons  2  select constraint_name, to_lob(search_condition)  3  from user_Constraints;7 rows created.SQL> col search_condition format a40SQL> select * from gtt_user_Cons  2  where search_condition like '%NOT NULL%';CONSTRAINT_NAME                SEARCH_CONDITION------------------------------ ----------------------------------------SYS_C0045146                   "EMPNO" IS NOT NULLSYS_C0052991                   "MIG_ID" IS NOT NULLSYS_C0052992                   "VRIEME" IS NOT NULLSYS_C0052988                   "MIG_ID" IS NOT NULLSYS_C0052989                   "VRIEME" IS NOT NULLSQL>

0 0
原创粉丝点击