_columns where index_owner='&owner' and table_name='&table_name'; 14. 查询数据表里的存储过程/函数/自定义类型/触发器/包
select * from dba_source
where onwer='&owner'
and type='&type';
15. 查询约束
select * from dba_constraints;
select * from all_constraints;
select * from user_constraints;
16. 查询同义词
select * from dba_synonyms;
select * from all_synonyms;
select * from user_synonyms;
17. 查询出发器
select * from dba_triggers;
select * from all_triggers;
select * from user_triggers;
18. 查询视图
select * from dba_views;
select * from all_views;
select * from user_views;
19. 查询序列
select * from dba_sequences;
select * from all_sequences;
select * from user_sequences;
20. 查询物化视图
select * from DBA_MVIEWS;
select * from ALL_MVIEWS;
select * from USER_MVIEWS;
21. 查询数据库对象
select * from DBA_OBJECTS;
select * from ALL_OBJECTS;
select * from USER_OBJECTS;
22. 查询存储过程
select * from DBA_PROCEDURES;
select * from ALL_PROCEDURES;
select * from USER_PROCEDURES;
23. 查询数据库表
select * from DBA_TABLES;
select * from ALL_TABLES;
select * from USER_TABLES;
24. 查询数据库表的列
select * from DBA_TAB_COLUMNS;
select * from ALL_TAB_COLUMNS;
select * from USER_TAB_COLUMNS;
select * from DBA_TAB_COLS;
select * from ALL_TAB_COLS;
select * from USER_TAB_COLS;
25. 查询数据库表列的备注
select * from DBA_TAB_COMMENTS;
select * from ALL_TAB_COMMENTS;
select * from USER_TAB_COMMENTS;
26. 查看查询的执行计划
explain plan for select * from dict;
select * from table(dbms_xplan.display);
持续更新中...
----------------------------------------------------------------------------------------------------------------------------------------------------
如果您们在尝试的过程中遇到什么问题或者我的代码有错误的地方，请给予指正，非常感谢！
联系方式：david.louis.tian@outlook.com
版权＠：转载请标明出处！