Oracle PL/SQL/Object Oriented Database/value
Use value() function to retrieve object table row
<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> select value(a) from address_table a
2 /
no rows selected SQL> SQL> drop table address_table; Table dropped. SQL> SQL>
</source>