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博客 ” ，链接：https://blog.itpub.net/26521853/viewspace-1278243/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
物化视图LOG的内容变化实验
请登录后发表评论
登录
全部评论
最新文章
- 获取对象DDL语句的方法
- Oracle+高性能SQL引擎剖析：SQL优化与调优机制详解-笔记之执行计划（二）
- Oracle+高性能SQL引擎剖析：SQL优化与调优机制详解-笔记之执行计划（一）
- COGNOS #PROMPT与#PROMPTMANY的语法笔记
- V$SESSION的SID&SERIAL#
- 物化视图LOG的内容变化实验
- 创建物化视图时报错ORA-16000
- 学习Join View-Key-Preserved Tables以及DML Statements on a join view
- 使用Oracle 10g引入的Partition Outer Joins进行统计报表的实现
- LIKE / NOT LIKE 改写
