티스토리 뷰

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/01   »
    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 31    
링크
공지사항
Total
68,406
Today
0
Yesterday
23