Re: display Oracle function objects source code / SQL

From: Sven Aluoor <aluoor@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Mon, 21 Jun 2010 15:17:28 +0200

On Mon, Jun 21, 2010 at 3:01 PM, Dunbar, Norman
<norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> Hi Sven,

> You need to look in the USER_SOURCE view:
>
>        Select text
>        from user_source
>        where type = 'FUNCTION'
>        and name = 'WHATEVER'
>        order by line;

[...]

Hi folks

thanks for all answers.

have a nice day

cheers Sven
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: display Oracle function objects source code / SQL
From: Joel.Patterson

References:
- display Oracle function objects source code / SQL
  - From: Sven Aluoor
- RE: display Oracle function objects source code / SQL
  - From: Dunbar, Norman

Re: display Oracle function objects source code / SQL

Other related posts: