Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: View for object_type
"JK Yao" <jkyf0131_at_hotmail.com> a écrit dans le message news:
93f65984.0109070121.6619e9b0_at_posting.google.com...
> dear all,
>
> Does anyone know which view shows which kind of object has which
> object_ID?
> Does any object has columns which show their type, such as table,
> view, package ...etc?
>
> Please share.
> Thanks a lot.
>
> JK
xxx_objects views give you the object_type for an object:
v815> desc dba_objects
Name
-- Have a nice day MichelReceived on Fri Sep 07 2001 - 04:26:36 CDT