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 a40 SQL> select * from gtt_user_Cons 2 where search_condition like '%NOT NULL%'; CONSTRAINT_NAME SEARCH_CONDITION ------------------------------ ---------------------------------------- SYS_C0045146 "EMPNO" IS NOT NULL SYS_C0052991 "MIG_ID" IS NOT NULL SYS_C0052992 "VRIEME" IS NOT NULL SYS_C0052988 "MIG_ID" IS NOT NULL SYS_C0052989 "VRIEME" IS NOT NULL SQL>
如何查看user_constraints里的search_condiction

最新推荐文章于 2021-04-09 23:56:23 发布
