Re: Text of stored procedures

A copy of this was sent to jdege_at_jdege.visi.com (Jeffrey C. Dege) (if that email address didn't require changing) On Tue, 12 Oct 1999 14:07:45 GMT, you wrote:

>How do I get the text of all the stored procedures in an Oracle database?
>I know they are in a system table somewhere, and I can view them one
>at a time in one of the enterprise manager tools, but I'd really
>like to grab them all to a text file, so I can search them all for
>2-digit years in date formats, etc. (Rather than loading them
>one-by-one.)

check out the *_source tables (* = all, user and dba)

don't unload em - use SQL (
select * from all_source where upper(line) like '%-YY''' ) for example

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Oct 12 1999 - 09:21:23 CDT