Re: getting functions-source out of the databse

You can write a sql script with spooling. Set the heading off and do
select text from user_source;

or if you have Procedure builder or Forms Desinger, you can look at the database object and drag the program units you need to a local file system.

HTH Prasad Chavali
pchavali_at_assettech.com

Gerben Scherpenzeel wrote in message <35A6D2C8.6FB26303_at_supportmagic.nl>...
>how can I get a list of functions, complete with the creation text, out
>of the Oracle Database? I know the information is stored in a view
>called ALL_SOURCE, but each line in a function definition is a record in
>this view. Is there an easy way of geting on line per function with the
>complete body of the function in it?
>
Received on Fri Jul 10 1998 - 20:25:00 CEST