select TABLE_name from all_tables WHERE owner='SYS';
/*
Oracle中:
select TABLE_name from all_tables WHERE owner='数据用户名'
就显示出了该用户可以访问到的表了
MySQL中:
show tables;
SqlServer中
select * from sysobjects where xtype ="U"
*/
select table_name from user_tables;
select * from tab where tabtype ='TABLE';