Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to view PL/SQL code for a procedure?

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

From: yossarian99 <yossarian99_at_operamail.com>
Date: Mon, 24 Jul 2006 13:25:11 +0200
Message-ID: <44c4ae19$0$1003$5fc30a8@news.tiscali.it>


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 - 06:25:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US