How to select from an object table

I created an type called address_ty
SQL> desc address_ty

 Name                            Null?    Type
 ------------------------------- -------- ----
 STREET                                   VARCHAR2(50)
 CITY                                     VARCHAR2(25)
 STATE                                    CHAR(2)
 ZIP                                      NUMBER

SQL> create table xyz
  2 (name varchar2(20),
  3 address address_ty);

Table created.

  1* insert into xyz values ('rama',address_ty('4913 woodman park dr #5','dayton','oh',45432))

1 row created.

But when I issue the command

SQL> select * from xyz where adderss_ty.state='oh';

I get an error saying invalid columnn;

Could somebody suggest the right syntax to be used for this select query.

Thanks in Advance

rama
rkolluru_at_csc.com Received on Fri Jun 19 1998 - 21:14:42 CEST