Re: Describe command equivalent query

SELECT OBJECT_NAME, OBJECT_TYPE, STATUS

            FROM SYS.ALL_OBJECTS
            WHERE OBJECT_TYPE IN ('PACKAGE BODY')
            AND OWNER = 'OWNER_NAME'

Regards
Bagieta
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

dbDeveloper - Multiple databases editor

http://prominentus.com
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Received on Wed Jun 23 2004 - 02:20:41 CDT