note of Beginning Oracle SQL-Oracle Data Dictionary Views
Table 3-5. Some Useful Oracle Data Dictionary Views
| View | Description |
| DICTIONARY | Description of the data dictionary itself |
| DICT_COLUMNS | Data dictionary column descriptions |
| ALL_USERS | Information about all database users |
| ALL_INDEXES | All indexes |
| ALL_SEQUENCES | All sequences |
| ALL_OBJECTS | All objects |
| ALL_SYNONYMS | All synonyms |
| ALL_TABLES | All tables |
| ALL_VIEWS | All views |
| USER_INDEXES | Indexes |
| USER_SEQUENCES | Sequences |
| USER_OBJECTS | Objects |
| USER_SYNONYMS | Synonyms |
| USER_TABLES | Tables |
| USER_TAB_COLUMNS | Columns |
| USER_VIEWS | Views |
| USER_RECYCLEBIN | Dropped objects |
| CAT | Synonym for USER_CATALOG |
| COLS | Synonym for USER_TAB_COLUMNS |
| DICT | Synonym for DICTIONARY |
| DUAL | Dummy table, with one row and one column |
| IND | Synonym for USER_INDEXES |
| OBJ | Synonym for USER_OBJECTS |
| SYN | Synonym for USER_SYNONYMS |
| TABS | Synonym for USER_TABLES |
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26521853/viewspace-1278243/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- About Static Data Dictionary ViewsView
- Public Synonyms for Data Dictionary Views (263)View
- Oracle 19c Concepts(06)：Data Dictionary and Dynamic Performance ViewsOracleORMView
- Structure of the Data Dictionary : User-Accessible Views (259)StructView
- Step 9: Run Scripts to Build Data Dictionary Views (67)UIView
- Some Dictionary Views For ASMViewASM
- How Oracle Uses the Data Dictionary (262)Oracle
- How to get ORACLE_HOME from data dictionaryOracle
- data dictionary（資料字典）
- Structure of the Data Dictionary : Base Tables (258)Struct
- Oracle10g資料字典（Data Dictionary for Oracle 10g）-ztOracle 10g
- Materialized Views in data warehouse environment (185)ZedView
- Cache the Data Dictionary for Fast Access (264)AST
- Materialized Views in data distributed environment (186)ZedView
- Oracle's V$ Views(轉)OracleView
- Keeping the Data Dictionary Cache Hit Ratio at or above 95 Percent
- Oracle 10G V$ViewsOracle 10gView
- school dictionary, kids dictionary, children dictionary
- SQL*Net more data from dblink Reference NoteSQL
- Oracle Materialized Views Containing Joins OnlyOracleZedViewAI
- oracle O7_DICTIONARY_ACCESSIBILITY 引數Oracle
- Oracle Data BufferOracle
- oracle data guard!!Oracle
- oracle data pumpOracle
- DML ViewsView
- Beginning ASP.NET in C#ASP.NETC#
- GYOI Beginning Contest #1 -zh
- 【檢視】oracle 資料字典檢視之 DICT / DICTIONARYOracle
- Oracle Flashback Data ArchiveOracleHive
- Oracle Data Guard配置Oracle
- ARABIC-ENGLISH DICTIONARY: THE HANS WEHR DICTIONARY OF MODERN WRITTEN ARABIC
- 8.1.1 V$ ViewsView
- 8.1.2 GV$ ViewsView
- Parallel query & viewsParallelView
- External Views (33)View
- Overview of Views (174)View
- Beginning JavaFX .pdf 免費下載Java
- CF1534G A New Beginning