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

Home -> Community -> Usenet -> c.d.o.misc -> Re: ANTOHER BEGINNER QUESTION

Re: ANTOHER BEGINNER QUESTION

From: Ed Prochak <prochak_at_my-deja.com>
Date: Fri, 17 Dec 1999 17:37:17 GMT
Message-ID: <83dscd$1k5$1@nnrp1.deja.com>

Look in the USER_SOURCE table with something like:

  SELECT line, text
    FROM USER_SOURCE
   WHERE name = 'MY_PROCEDURE'
   ORDER BY line ;

HTH
  Ed

In article <83dls5$sj7$1_at_nnrp1.deja.com>,   texas_mike_at_my-deja.com wrote:
> How do I view the code behind the stored procedures in the database?
>
> Thanks.
> --
> -----------------------------
> TEXAS_MIKE_at_MY-DEJANEWS.COM
> Hey haven't we met?
> -----------------------

--
Ed Prochak
Magic Interface, Ltd.
ORACLE Development, conversions, training and support 440-498-3700 magic_at_interfacefamily.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 17 1999 - 11:37:17 CST

Original text of this message

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