ORCALE中统计数据表的总个数:SELECT count(*) FROM dba_tables WHERE owner='用户名' ————有DBA权限
SELECT count(*) FROM all_tables WHERE owner='用户名' ————普通用户权限
ORCALE获得表名:
SELECT name FROM dba_tables WHERE owner='用户名'
SELECT name FROM all_tables WHERE owner='用户名'