Oracle PL/SQL/Object Oriented Database/value

Материал из SQL эксперт
Перейти к: навигация, поиск

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>