select OBJECT_NAME from dba_objects where OBJECT_TYPE='TABLE'
select table_name, comments from user_tab_comments; SELECT table_name FROM User_All_Tables;提供两个 第一个可以带comment一起查出 第二个只能查到表名
汇总各位的如下: SELECT * FROM user_tab_comments; SELECT * FROM User_All_Tables; SELECT * FROM tab; select * from dba_objects where OBJECT_TYPE='TABLE'; select * from all_tables; SELECT * FROM user_tables ; SELECT * FROM user_objects ;
select count(*) from user_tables; -- 当前用户下所有的表 select count(*) from all_tables; -- 当前用户可以访问的表 select count(*) from dba_tables; -- 系统中所有的表
where OBJECT_TYPE='TABLE'
select table_name, comments from user_tab_comments;
SELECT table_name FROM User_All_Tables;提供两个 第一个可以带comment一起查出 第二个只能查到表名
SELECT * FROM user_tab_comments;
SELECT * FROM User_All_Tables;
SELECT * FROM tab;
select * from dba_objects where OBJECT_TYPE='TABLE';
select * from all_tables;
SELECT * FROM user_tables ;
SELECT * FROM user_objects ;
select count(*) from all_tables; -- 当前用户可以访问的表
select count(*) from dba_tables; -- 系统中所有的表