good point! forgot about packages :)
--- Pat Hildebrand <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> > >
> > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
