oracle数据库数据字段视图
1、获取“小”视图,主要用于用户级别使用
SELECT * FROM dict WHERE table_name NOT LIKE '%$%' AND table_name NOT LIKE '%\_%' ESCAPE '\' AND LENGTH (table_name) < 10 ORDER BY 1;
结果:
TABLE_NAME COMMENTS
------------------------------ --------------------------------------------------------------------------------
CAT Synonym for USER_CATALOG --含有table、seq、view
CLU Synonym for USER_CLUSTERS
COLS Synonym for USER_TAB_COLUMNS --表字段
DICT Synonym for DICTIONARY --数据字典表
DUAL
IND Synonym for USER_INDEXES --索引
OBJ Synonym for USER_OBJECTS --包含cat与tabs
SEQ Synonym for USER_SEQUENCES --序列
SYN Synonym for USER_SYNONYMS --
TABS Synonym for USER_TABLES --含table、view