티스토리 뷰

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.


등등...

댓글
«   2024/11   »
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
Today
Yesterday