database►oracle

显示oracle对象

dba,all,user三种级别

1
2
3
4
5
6
7
8
9
10
11
12
13
14
select view_name from dba_views
--for all accessible views (accessible by logged user)
select view_name from all_views
--for views owned by logged user
select view_name from user_views
--for views owned by current logged user
SELECT view_name, owner
FROM sys.all_views
ORDER BY owner, view_name

通过OBJECTS查找

1
2
3
4
5
--USER_OBJECTS:
SELECT *
  FROM USER_OBJECTS
 WHERE object_type = 'PROCEDURE'
   AND object_name = 'MY_STORED_PROCEDURE'

查找包源码

1
2
3
4
5
6
7
8
9
10
11
12
13
--查找包
 SELECT *
    FROM all_source
   WHERE TYPE = 'PACKAGE BODY' AND name = '<your package name>'
ORDER BY line;
--查找包源码
SELECT line, text
FROM dba_source
WHERE owner = ?
  AND name = ?
  AND type = 'PROCEDURE'
ORDER BY line

查找视图源码

1
2
--查找视图源码
SELECT view_name, text FROM user_views;