| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|  |  | |||
Home -> Community -> Mailing Lists -> Oracle-L -> re : Where are procedures names
Hi
You can get procedure, function, and package names from
SELECT DISTINCT NAME FROM ALL_SOURCE ORDER BY 1;
But what is FORM_PROCEDURE ???
> Date sent:      Thu, 9 Mar 1995 21:47:17 -0536
> Send reply to:  "ORACLE database mailing list." <ORACLE-L@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 - 19:44:15 CST
|  |  |