Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Stored procedures - find all within a database
Arj schrieb:
> Can someone give me an sql statement to find all the stored procedures
> within a database.
>
> Thanks,
> Arj
select owner, object_name, object_type
from sys.all_objects
where object_type in ('PROCEDURE', 'FUNCTION')
and owner = user
Received on Mon Jul 28 2003 - 12:52:54 CDT