OraFAQ Forum: SQL & PL/SQL » How to see my procedure/function code ?

Home » SQL & PL/SQL » SQL & PL/SQL » How to see my procedure/function code ?

Sat, 20 July 2002 12:58

Murali
Messages: 54
Registered: December 1999

Member

Hi,
I am a beginner in pl/sql. Can somebody suggest me, how to see my procedure/function code ?

Sun, 21 July 2002 02:53

Rohit Mehrotra
Messages: 9
Registered: July 2002

Junior Member

use this

select text from user_source where name ='YOUR FUNCTION/PROCEDURE NAME';

Rohit

Tue, 23 July 2002 05:54

saravanan
Messages: 70
Registered: October 2000

Member

hi
try this

edit my_procedure

my_procedure should replace ur procedure name

Previous Topic:	SQL*Loader troubles
Next Topic:	how can i print name

Goto Forum:

]

Current Time: Wed Apr 17 21:51:45 CDT 2024