Oracle字典表

--查询某个表在哪些存储过程中被调用
select * from user_source e where e.TYPE='PROCEDURE' and upper(e.TEXT) like '%%';

--查看表的创建日期
select CREATED,LAST_DDL_TIME,s.* from user_objects s where object_name=upper('ABC');

--Oracle查询某个字段名出现在哪些表中
SELECT table_name, column_name, s.*
FROM user_tab_columns s
WHERE column_name LIKE '%GETNOTICENO%';

--查询主键冲突对应的表
SELECT cc.*
FROM user_cons_columns cc, user_constraints cs
WHERE cc.constraint_name = cs.constraint_name
AND cs.constraint_type = 'P'
AND cc.CONSTRAINT_NAME = 'SQL111020162648670';