Home » SQL & PL/SQL » SQL & PL/SQL » HOW TO LOOK UP THE CONTENT OF THE PROCEDURE?
HOW TO LOOK UP THE CONTENT OF THE PROCEDURE? [message #19305] Mon, 11 March 2002 05:31 Go to next message
Sabrina
Messages: 76
Registered: February 2002
Member
I know you can the NAME OF THE PROCEDURE by looking up in the table USER_PROCEDURES.
But is there a way, where i can lookup at the actual content of the procedure?

-Thanks.
Re: HOW TO LOOK UP THE CONTENT OF THE PROCEDURE? [message #19306 is a reply to message #19305] Mon, 11 March 2002 05:34 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select text from user_source where name ='PROCEDURE_NAME'
Previous Topic: Triggers
Next Topic: date column with format hh24:mi:ss
Goto Forum:
  


Current Time: Thu Mar 28 03:46:21 CDT 2024