Re: display Oracle function objects source code / SQL

if you are going to use sql*plus to extract the code then make sure that
line column is included in order by and text is 4000 VC2 so provide
suffcient value long parameter of sql*plus environment. toad is better for
such labour work

thanks..subodh

On 21 June 2010 18:20, Sven Aluoor <aluoor@xxxxxxxxx> wrote:

> Hi folks
>
> With this SQL statement I display all functions with their names
>
> SQL> select object_name, status from user_objects
>  2  where object_type = 'FUNCTION';
>
> [...]
>
> 14 rows selected.
>
> But how to show the source code / SQL of this functions?
>
> (I did this with TOAD, but here I have no TOAD)
>
> cheers
> Sven
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================

Other related posts: