1、查有几张表
select * from tab;
select * from cat;
select * from user_tables;
select TABLE_NAME from user_tables;
2、查包含字段NAME的所有表
select TABLE_NAME , COLUMN_NAME,DATA_TYPE from USER_TAB_COLS where COLUMN_NAME = 'NAME';1、查有几张表
select * from tab;
select * from cat;
select * from user_tables;
select TABLE_NAME from user_tables;
2、查包含字段NAME的所有表
select TABLE_NAME , COLUMN_NAME,DATA_TYPE from USER_TAB_COLS where COLUMN_NAME = 'NAME';