Viewing SP from sql plus window [message #71237] |
Sun, 29 September 2002 22:48  |
rajesh
Messages: 173 Registered: November 1998
|
Senior Member |
|
|
hi
I don't have TOAD installed in my machine. Is it possible to see the code of a compiled stored procedure(or a function) from the SQL PLUS window?
If yes, please send me the required select statement to view the code.
|
|
|
|
Re: Viewing SP from sql plus window [message #71242 is a reply to message #71237] |
Mon, 30 September 2002 04:21  |
Srinivas
Messages: 138 Registered: June 2000
|
Senior Member |
|
|
Try this select statement to see the coding in a stored procedure from SQL prompt (SQL plus).
select text from USER_SOURCE where name='spname' ;
Note that in the above statement, spname is your procedure name.
Another way to see the code written in a stored procedure is by using DBA studio. You can have a gui based screen when you can see many things.
Best of luck
|
|
|