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