Re: display Oracle function objects source code / SQL
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: aluoor@xxxxxxxxx
- Date: Mon, 21 Jun 2010 14:54:14 +0200
Check the DBA_SOURCE view.
Stefan
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Mon, Jun 21, 2010 at 2: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
>
>
>
Other related posts:
