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).
