How Do I Get the Attribute of My Object Type in SQL?

DZone Database Zone

How Do I Get the Attribute of My Object Type in SQL?

This question found its way into my inbox yesterday:

I have a table with an object type column. I want to way to get the value of an attribute of that object type in my query. But Oracle keeps telling me "ORA-00904: invalid identifier". What am I doing wrong?

Almost certainly what you are doing wrong is forgetting to use a table alias. Yeah, it's that simple.

more info...