티스토리 뷰

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/04   »
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