第2个回答 2019-08-15
查看哪些表包含username字段
select table_name from user_tab_columns where column_name = 'USERNAME';
select table_name from all_tab_columns where column_name = 'USERNAME';
查看存储过程包含username字段
select * from user_source where type = 'PROCEDURE' and upper(text) like '%USERNAME%';
select * from all_source where type = 'PROCEDURE' and upper(text) like '%USERNAME%';