select tname from tab where TABTYPE='TABLE';与user_tables表的数据是等价的。 TABTYPE不一定只是表,也有可能是view等,所以你要选出来TABTYPE='TABLE'的所有表
TAB CAT all_tables 能说的具体点,三者
请问CAB和TAB的区别是什么呢?谢谢!
sys@ORCL> desc cat Name Null? Type ----------------------------------------------------- -------- ------------------------------------ TABLE_NAME NOT NULL VARCHAR2(30) TABLE_TYPE VARCHAR2(11)sys@ORCL> desc tab Name Null? Type ----------------------------------------------------- -------- ------------------------------------ TNAME NOT NULL VARCHAR2(30) TABTYPE VARCHAR2(7) CLUSTERID NUMBERsys@ORCL> select * from dict where table_name='CAT';TABLE_NAME COMMENTS ---------- ----------------------------------- CAT Synonym for USER_CATALOG sys@ORCL> select * from dict where table_name='USER_CATALOG';TABLE_NAME COMMENTS -------------------- ----------------------------------------------------------------- USER_CATALOG Tables, Views, Synonyms and Sequences owned by the user
CAT
all_tables
能说的具体点,三者
请问CAB和TAB的区别是什么呢?谢谢!
sys@ORCL> desc cat
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)sys@ORCL> desc tab
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
TNAME NOT NULL VARCHAR2(30)
TABTYPE VARCHAR2(7)
CLUSTERID NUMBERsys@ORCL> select * from dict where table_name='CAT';TABLE_NAME COMMENTS
---------- -----------------------------------
CAT Synonym for USER_CATALOG
sys@ORCL> select * from dict where table_name='USER_CATALOG';TABLE_NAME COMMENTS
-------------------- -----------------------------------------------------------------
USER_CATALOG Tables, Views, Synonyms and Sequences owned by the user