Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Describe command equivalent query
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