Oracle all_source

These are the query to display the source for an Oracle stored procedure/ function, trigger, etc :

• all_source describes the text source of the stored objects accessible to the current user.

select * from all_source;

• user_source describes the text source of the stored objects owned by the current user.

select * from user_source;

Here is the list of columns for all_source. As for user_source, it does not display the OWNER column.

 Name Type
-------------------------------
 OWNER VARCHAR2(30) 
 NAME VARCHAR2(30)
 TYPE VARCHAR2(12)
 LINE NUMBER
 TEXT VARCHAR2(4000)

select text from all_source
 where name = 'proc_name'
 order by line;

 

visit Oracle Database References