Use user-defined type in insert statement : Object Table Insert « Object Oriented Database « Oracle PL / SQL





Use user-defined type in insert statement

  

SQL> create type addressType as object
  2  (Street  VARCHAR2(50),
  3   City    VARCHAR2(25),
  4   State   CHAR(2),
  5   Zip     NUMBER);
  6  /
SQL> create type personType as object
  2  (Name     VARCHAR2(25),
  3   Address  addressType);
  4  /
SQL>
SQL>
SQL> create table CUSTOMER(
  2    cid  NUMBER,
  3    Person       personType
  4  );
SQL>
SQL> insert into CUSTOMER values(1,personType('SomeName',addressType('Street','City','ST',11111)));
SQL> insert into CUSTOMER values(1,personType('SomeName',addressType('Street2','City2','ST',11111)));
SQL>
SQL> drop type personType force;
SQL>
SQL> drop type addressType force;
SQL>
SQL> drop table CUSTOMER;

   
    
  










Related examples in the same category

1.Insert data to table containing object column
2.Insert statement with nested type