티스토리 뷰
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 |