dba_source
Name Type
---------- --------------
OWNER VARCHAR2(30)
NAME VARCHAR2(30)
TYPE VARCHAR2(12)
LINE NUMBER
TEXT VARCHAR2(4000)
A view of source code for all objects in the database:. For example, if I run the following query in my test database...
select text
from dba_source
where name = 'TEST_PROC'
and type = 'PROCEDURE'
order by line
/
...I get the following output:
TEXT
--------------------------------------------------------------------------------
procedure test_proc is
i number;
begin
for i in 1 .. 60 loop
sys.dbms_lock.sleep(1);
end loop;
end;
7 rows selected.
For more useful DBA queries click here.
| 