Object table insert : Insert « Object Oriented Database « Oracle PL / SQL

1. Oracle PL / SQL
2. Object Oriented Database
3. Insert

Object table insert

 
SQL>
SQL> create or replace type address_type
  2    as object
  3    ( city    varchar2(30),
  4      street  varchar2(30),
  5      state   varchar2(2),
  6      zip     number
  7    )
  8  /

Type created.

SQL> create or replace type person_type
  2    as object
  3    ( name             varchar2(30),
  4      dob              date,
  5      home_address     address_type,
  6      work_address     address_type
  7    )
  8  /

Type created.

SQL>
SQL>
SQL> create table people1 of person_type
  2  /

Table created.

SQL>
SQL>
SQL> desc people
ERROR:
ORA-24372: invalid object for describe


SQL>
SQL>
SQL> insert into people1 values ( 'Tom', '15-mar-1965',
  2    address_type( 'Reston', '123 Main Street', 'Va', '45678' ),
  3    address_type( 'Redwood', '1 Oracle Way', 'Ca', '23456' ) );

1 row created.

SQL> /

1 row created.

SQL>
SQL>
SQL> select * from people1;
NAME                 DOB
-------------------- --------------------
HOME_ADDRESS(CITY, STREET, STATE, ZIP)
------------------------------------------------------------------------------------------------------------------------------------------------------
WORK_ADDRESS(CITY, STREET, STATE, ZIP)
------------------------------------------------------------------------------------------------------------------------------------------------------
Tom                  15-MAR-1965 00:00:00
ADDRESS_TYPE('Reston', '123 Main Street', 'Va', 45678)
ADDRESS_TYPE('Redwood', '1 Oracle Way', 'Ca', 23456)

Tom                  15-MAR-1965 00:00:00
ADDRESS_TYPE('Reston', '123 Main Street', 'Va', 45678)
ADDRESS_TYPE('Redwood', '1 Oracle Way', 'Ca', 23456)


2 rows selected.

SQL>
SQL>
SQL> drop table people1;

Table dropped.

SQL> drop type person_type;

Type dropped.

SQL> drop type address_type;

Type dropped.

SQL>
SQL> --

 

Related examples in the same category