Re: display Oracle function objects source code / SQL
- From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- To: aluoor@xxxxxxxxx
- Date: Mon, 21 Jun 2010 19:34:11 +0530
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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
==============================
DO NOT FORGET TO SMILE TODAY
==============================
Other related posts:
