Are there any tables of interest regarding a connection between object tables & objects types? I mean tables from the dictionary (DICT).
I looked into these 2:
SELECT * FROM USER_OBJECTS
SELECT * FROM USER_OBJECT_TABLES
What I am interested is to find out if object table 'A' contains/can contain object type 'b' instances? Obviously table 'A' is table of object 'a' and 'b' is under 'a'.
Have any ideas? Advices? Should i resume to a query on my table 'A'? And if i should, how do I find out if selected object from table 'A' is a instance of 'a' or 'b'?
I'm not sure what you're trying, but there is the USER_TYPES dictionary view that holds the hierarchy of the objects, so you can write some sql query like (example is not perfect, I know):
and find all the types which are under the type of the table