Re: getting functions-source out of the databse

Gerben,

    You can do this with a combination of sql and awk. Basically, spool out the source in name, line order. Then run that spool file through an awk script that will break it down into separate files as needed.

Hope this helps.

Chuck
#include <std_disclaimer.h>

Gerben Scherpenzeel <gerben_at_supportmagic.nl> wrote in article <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 - 21:38:49 CEST