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 -> How to view PL/SQL code for a procedure?

How to view PL/SQL code for a procedure?

From: Sameer <dolpheen_at_gmail.com>
Date: 24 Jul 2006 03:41:54 -0700
Message-ID: <1153737714.159744.291090@75g2000cwc.googlegroups.com>


Hello,
I am using Oracle 8i. I have created several procedure in the database. Once they are created, they are part of database. This is being part of Oracle Data Dictionary, be stored in one of the table.
Can we see the code of these procedures? I know that it is possible using tool like SQL Developer or Toad, but how to do this in SQL * Plus?
Please help.
-Sameer Received on Mon Jul 24 2006 - 05:41:54 CDT

Original text of this message

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