Oracle&Sybase里查看所有表的SQL

Oracle
=======================

select   table_name   from   user_tables;     //当前用户的表   
    
select   table_name   from   all_tables;     //所有用户的表   
    
select   table_name   from   dba_tables;       //包括系统表

select   table_name   from   dba_tables   where   owner='用户名'

Sybase
=======================

select count(1) from sysobjects where type='U'