Re: How to view PL/SQL code for a procedure?

From: Sameer <dolpheen_at_gmail.com>
Date: 24 Jul 2006 06:22:58 -0700
Message-ID: <1153747378.401982.76950@i42g2000cwa.googlegroups.com>

I got it by giving:

SELECT TEXT FROM USER_SOURCE WHERE NAME='PROCEDURE-NAME'; Thanks a lot.

yossarian99 wrote:
> Sameer wrote:
>
> > I know that it is possible using tool like SQL Developer or Toad, but
> > how to do this in SQL * Plus?
>
> By querying dictionary views %SOURCE.
>
> Kind regards,
>
> --
> yossarian99 (spamto:yossarian99_at_operamail.com)
>
> it doesn't make a damned bit of difference
> who wins the war to someone who's dead
Received on Mon Jul 24 2006 - 08:22:58 CDT