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: Describe command equivalent query

Re: Describe command equivalent query

From: Bagieta <bagieta21_at_poczta.onet.pl>
Date: Wed, 16 Jun 2004 08:55:25 +0200
Message-ID: <caor5l$aok$1@news.onet.pl>


SELECT OBJECT_NAME, OBJECT_TYPE, STATUS

            FROM SYS.ALL_OBJECTS
            WHERE OBJECT_TYPE IN ('FUNCTION', 'PROCEDURE', 'TRIGGER',
'PACKAGE')
            AND OWNER = 'OWNER_NAME'

Best regards
Bagieta
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

dbDeveloper - Multiple databases editor

http://prominentus.com
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Received on Wed Jun 16 2004 - 01:55:25 CDT

Original text of this message

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