티스토리 뷰
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.
등등...
'Programming > SQL' 카테고리의 다른 글
[Oracle] 에러 코드 (0) | 2016.03.20 |
---|---|
[MySQL] Database 백업 및 복원 (0) | 2016.01.20 |
[MySQL] ORDER BY 절을 이용한 다양한 방법 (0) | 2015.08.11 |
[MySQL] WHERE 조건절을 이용한 다양한 방법 (0) | 2015.08.06 |
[MySQL] PADSPACE - trailing spaces (0) | 2015.07.03 |
[MySQL] Specific Code (0) | 2015.07.03 |
[MySQL] User 생성 및 삭제 (권한 관리) (0) | 2015.05.12 |