查看用户所拥有的表:
SELECT TABLE_NAME FROM USER_TABLES;
用户可存取的表:
SELECT TABLE_NAME FROM ALL_TABLES;
数据库中所有表:
SELECT TABLE_NAME FROM DBA_TABLES;
SELECT TABLE_NAME FROM USER_TABLES;
用户可存取的表:
SELECT TABLE_NAME FROM ALL_TABLES;
数据库中所有表:
SELECT TABLE_NAME FROM DBA_TABLES;
或者
select * from tab;