Home » SQL & PL/SQL » SQL & PL/SQL » How can i get the content of procudure from sqlplus?
How can i get the content of procudure from sqlplus? [message #38257] Thu, 04 April 2002 16:48 Go to next message
sztangxy
Messages: 1
Registered: April 2002
Junior Member
How can i get the content of procudure from sqlplus?
I can only show the parameters of the procedure using
the "desc procedurename" command.who can help me.thanks!!

Report message to a moderator

Re: How can i get the content of procudure from sqlplus? [message #38258 is a reply to message #38257] Thu, 04 April 2002 17:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use this query with few changes accordingly
u can use user_source / dba_source
sql> select name,text from dba_source where name='ur_procedure" and owner='scott';

Report message to a moderator

Re: How can i get the content of procudure from sqlplus? [message #38265 is a reply to message #38257] Fri, 05 April 2002 07:33 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
http://asktom.oracle.com/pls/ask/f?p=4950:8:663836::NO::F4950_P8_DISPLAYID

Report message to a moderator

Previous Topic: Validating a Number Value
Next Topic: null parameters in a PL/SQL procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 03 16:40:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.