Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> re : Where are procedures names
Howdy:
To get Procedure names, Package Names, and Function nanes:
SELECT distinct name from all_source order by 1;
BUT WHAT IS THIS 'FORM PROCEDURE' ??? ^^^^^^^^^^^^^^
> Date sent: Thu, 9 Mar 1995 21:47:17 -0536
> Send reply to: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu>
> From: MAHESH BHAT <mahesh_at_WSLVAX1.WIPSYS.SOFT.NET>
> Subject: re : Where are procedures names
> Originally to: oracle-l_at_ccvm.sunysb.edu
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_CCVM.sunysb.edu>
> Hi...
>
> You can get the procedure names by the query :
>
> select procname from form_procedure;
>
> Rest of the details of the procedures are in FORM_PROCEDURE itself.
> Allen G. Wells (612)627-5492 FAX: (612)627-5479
MN Dept of Health, Enviromental Health Division
Internet: Allen.Wells_at_health.state.mn.us
Received on Sat Mar 11 1995 - 20:54:40 CST