Re: display Oracle function objects source code / SQL
- From: David Roberts <big.dave.roberts@xxxxxxxxxxxxxx>
- To: aluoor@xxxxxxxxx
- Date: Mon, 21 Jun 2010 14:00:09 +0100
http://www.shutdownabort.com/dbaviews/dba_source.php
Gives the solution for procedures, the solution for functions is
essentially the same, but with the string 'FUNCTION' replacing the
string 'PROCEDURE'.
Packages are fractionly more complex as they will have 2 entries, one
'PACKAGE' and the other 'PACKAGE BODY'.
Dave
On Mon, Jun 21, 2010 at 1:50 PM, 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
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
