Re: display Oracle function objects source code / SQL

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: