OraFAQ Forum: SQL & PL/SQL » get database procedures

Home » SQL & PL/SQL » SQL & PL/SQL » get database procedures

Sat, 05 January 2002 04:46

William Ospina
Messages: 1
Registered: January 2002

Junior Member

Hi...

How can I get all database procedures or just one giving procedure's name.

thanks

Sat, 05 January 2002 04:49

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

Select text from all_source where name='PROCEDURE_NAME_HERE';

Previous Topic:	Re: Encript Data
Next Topic:	Please help with a cursor function

Goto Forum:

]

Current Time: Sat Jan 10 15:56:25 CST 2026