Wednesday, March 13, 2013

get procedure list in oracle



SQL> SELECT object_name
2 FROM dba_objects
3 WHERE object_type = 'PROCEDURE' and owner='FAITH';



SELECT text FROM all_source WHERE owner = 'FAITH'
AND name = 'FAITHSUBUNSUB'
ORDER BY line;

No comments: