Re: Selecting Object Types

ncroston_at_cceb.med.upenn.edu (Nate Croston) wrote in <3AB79FE5.86205C06_at_cceb.med.upenn.edu>:

<snip>

>If I am not mistaking the syntax to query each attribute in the object
>type is COLUMN_NAME.ATTRIBUTE. So my query is SELECT
>HOSPITAL_ADDRESS.STATE FROM HOSPITAL. This is when I get the ORA-00904
>error.

Nate,

I believe you must use a table alias to access individual attributes of your object in SQL:

  SELECT H.HOSPITAL_ADDRESS.STATE FROM HOSPITAL H WHERE... HTH,
g

-- 
Gerard Averill
gaverill<at>chsra<dot>wisc<dot>edu