good point! forgot about packages :)
- Pat Hildebrand <pat_at_ssc.upenn.edu> wrote:
> It is also a good idea to include the type or you can end up with
> such
> confusing things as the text of a package mixed with the text of the
> package body.
>
> Pat
>
>
> >
> > SELECT TEXT
> > FROM DBA_SOURCE
> > WHERE NAME = 'object_name'
> > and owner='owner name'
> > order by line
> >
> > just in case two people own objects with the same name. And while
> it
> > MIGHT do the select in line order, it doesn't hurt to ensure that
> you
> > are reading the lines of code in the proper order :)
> >
> >
> > --- Bob Metelsky <bmetelsky_at_CPS92.COM> wrote:
> > > Thanks for all the replies...
> > >
> > > A summary
> > >
> > > {user|all|dba}_source
> > >
> > > LOCDB SQL> desc dba_source;
> > > Name
> > > ---------------------------
> > > OWNER
> > > NAME
> > > TYPE
> > > LINE
> > > TEXT
> > >
> > > LOCDB SQL> select distinct type from dba_source ;
> > > TYPE
> > > ------------
> > > FUNCTION
> > > PACKAGE
> > > PACKAGE BODY
> > > PROCEDURE
> > > TYPE
> > >
> > >
> > > SELECT TEXT FROM DBA_SOURCE WHERE NAME = 'object_name'
> > >
> > > bob
> > >
> > >
> > > > Im mucking about in the user_ views...
> > > >
> > > > Im seeing dba_objects type = 'procedure'; but need to find the
> sql
> > > >
> > > > Thanks
> > > > bob
> > > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Bob Metelsky
> > > INET: bmetelsky_at_cps92.com
> > >
> > > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting
> services
> > >
> ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
> in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You
> may
> > > also send the HELP command for other information (like
> subscribing).
> > >
> >
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Tax Center - forms, calculators, tips, more
> > http://taxes.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Rachel Carmichael
> > INET: wisernet100_at_yahoo.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting
> services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like
> subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Pat Hildebrand
> INET: pat_at_ssc.upenn.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Feb 20 2003 - 13:15:55 CST