Oracle中的部分查询

1.查询所有视图

   SELECT * FROM user_views;

2.查询所有触发器

   SELECT * FROM DBA_SOURCE  WHERE  TYPE='TRIGGER'; 或者 SELECT * FROM USER_SOURCE  WHERE  TYPE='TRIGGER';

3.查询所有存储过程

  SELECT * FROM USER_SOURCE WHERE TYPE='PROCEDURE';或者 SELECT DISTINCT NAME  FROM USER_SOURCE WHERE TYPE='PROCEDURE';