SQL 查找某个用户数据库中包含某个字段的所有表
2019-11-14 本文已影响0人
Rinaloving
列名大写,用户名大写
select table_name from DBA_TAB_COLUMNS where COLUMN_NAME='QSZT'AND TABLE_NAME not like ( '%BIN%') and owner='SUBMIT';
select table_name from DBA_TAB_COLUMNS where COLUMN_NAME='QSZT'AND TABLE_NAME not like ( '%BIN%') and owner='SUBMIT';