数据库表名列名查询

select table_name from ALL_TABLES where OWNER='PORTAL';
select * from dba_tables where owner='PORTAL';--用户名要大写!
select table_name from   user_tables ;