--查水表

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%';