Oracle数据库常用经典查询 - 数据库编程

_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

版权＠：转载请标明出处！

Oracle数据库常用经典查询(二)