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


Other related posts: