Oracle PL/SQL/Object Oriented Database/Where
Reference type attribute in a where clause
<source lang="sql">
SQL> SQL> create or replace
2 type address as object( 3 id number, 4 street varchar2(100), 5 state varchar2(2), 6 zipcode varchar(11) 7 ) 8 /
Type created. SQL> SQL> create table address_table of address
2 /
Table created. SQL> SQL> delete from address_table where id = 1
2 /
0 rows deleted. SQL> SQL> drop table address_table; Table dropped. SQL>
</source>