Sunday, June 22, 2008

procedures,functions,packages

select object_name from dba_objects where owner='jephe' and object_type='PROCEDURE';
note: select all procedures from jephe tablespace.

No comments: