Get attribute names of user-defined objects

Question

I want to generate a PL/SQL script that provide the attribute names of an object type defined by a user. I can see object types defined but I cant find attribute names of this object.

:Can you gave an example i am not getting exactly what you want ,and please update your oracle version — Gaurav Soni
– Gaurav Soni, Commented Oct 4, 2012 at 15:18

kevinskio · Accepted Answer · 2012-10-05 13:37:08Z

6

This works with Oracle 11g and should work with earlier versions

select attr_name 
from all_type_attrs
where owner = YourSchemaName
and type_name = YourTypeName

If this object is in another user's schema you will need to have the execute permission before you can see this in all_type_attrs.

(Edited for clarity on permissions from APC's comment)

edited Oct 5, 2012 at 13:37

answered Oct 4, 2012 at 15:20

kevinskio

4,5711 gold badge27 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

APC Over a year ago

Every user has access to the ALL_ views in the data dictionary. The thing is, they can only see data for objects which they have privileges on. That is, their own objects, things granted to PUBLIC and perhaps objects in other schemas. Perhaps you're getting confused with the DBA_ views?

Collectives™ on Stack Overflow

Get attribute names of user-defined objects

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related