Re: view procedures

From: Dmitry E. Loginov <dmitry_loginov_at_mtu.ru>
Date: Wed, 5 Dec 2001 00:04:20 +0300
Message-ID: <9ujdsu$614$1@gavrilo.mtu.ru>

DBA_SOURCE
USER_SOURCE Captured from TOAD:
select TEXT
  from DBA_SOURCE
  where OWNER= :lOWNER
    and NAME=:NAME
    and type = :BTYPE
  order by LINE

"Ed Lufker" <elufker_at_shimi.swcp.com> wrote in message news:9ujafe$6d1$1_at_sloth.swcp.com...
> Hi All:
>
> How do you look at the code that is part of a procedure???? What DBA views
> or tables will tell me this information?
>
> Thanks in advance for any help here.
> Eddie Lufker
Received on Tue Dec 04 2001 - 15:04:20 CST