| Display procedure contents [message #56463] |
Wed, 02 April 2003 02:37  |
James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)
|
Member |
|
|
How do you display the contents of a procedure.
Say there's a procedure called jimtest and you want to look at the SQL that makes up this procedure?
|
|
|
|
| Re: Display procedure contents [message #56466 is a reply to message #56463] |
Wed, 02 April 2003 07:01  |
Michel Bartov
Messages: 35
Registered: February 2003
|
Member |
|
|
I just posted an integrated set of GUI tools to administer the Oracle database.
One of the many functions is to view and maintain all database objects including stored objects such as functions, procedures etc…
You may need same help to get started, so feel free to contact me (michelbartov@yahoo.com). The link is http://www.barsoft.net/
Or you can use:
SELECT text
from DBA_SOURCE
where type='PROCEDURE'
and owner='JIM'
and name='JIMTEST'
order by line;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
