--查水表

select *from user_users; select *from user_tables; select *from user_tablespaces; select *from user_source;   select *from all_users; select *from all_tables; select *from all_source;   --区分大小写查询，也可以使用lower(xxx): SELECT * FROM CODE_LIBRARY WHERE upper(codeno) LIKE upper('certtype'); select * from dataobject_library t where upper(t.colname) = 'COUNTRY'; select * from dataobject_library t where lower(t.colname) = 'country'; select *from user_tables where upper(table_name) like '%LOG%';   --根据表名或内容查询存储过程 select * from user_dependencies where referenced_name = '表名' select distinct name from user_source where type = 'procedure' and upper(text) like '%内容%'   --通过存储过程查任务 select *from user_jobs where upper(what) like '%存储过程名%' --还有all_jobs   根据字段名查表名   --mysql use information_schema; select * from columns where column_name LIKE 'log_nr%' ;   --oracle select TABLE_NAME from user_tab_columns where lower(column_name)='namecode'; select TABLE_NAME from user_tab_columns where lower(column_name) like '%group%';