티스토리 뷰

Programming/SQL

[Oracle] Catalog

do9dark 2015.11.14 20:44

ALL_ALL_TABLES

ALL_ALL_TABLES describes all object tables and relational tables accessible to the current user.


ALL_TABLES

ALL_TABLES describes all relational tables accessible to the current user. To gather statistics for this view, use the SQL ANALYZE statement.


TABS

TABS is a synonym for USER_TABLES.


TAB

TAB is included for compatibility with Oracle version 5. Oracle Corporation recommends that you do not use this view.


ALL_CATALOG

ALL_CATALOG lists all indexes, tables, clusters, views, synonyms, and sequences accessible to the current user.


ALL_CLUSTERS

ALL_CLUSTERS describes all clusters accessible to the current user.


ALL_COL_COMMENTS

ALL_COL_COMMENTS lists comments on columns of tables and views accessible to the current user.


ALL_DB_LINKS

ALL_DB_LINKS describes database links accessible to the current user. This view does not display the PASSWORD column.


ALL_OBJECTS

ALL_OBJECTS describes all objects accessible to the current user.


ALL_OBJECT_TABLES

ALL_OBJECT_TABLES describes all object tables accessible to the current user.


등등...

댓글
댓글쓰기 폼
«   2019/06   »
            1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30            
링크
공지사항
Total
77,378
Today
88
Yesterday
103