Nested table | Oracle DBA Tutorial pdf

Nested table

create type objAddress as object
(HouseNo varchar2(20),
Street varchar2(200),
City varchar2(50),
State char(2),
PostCode varchar2(10))
/
create type oAddress as table of objAddress
/
create table People
(No number,
Name varchar2(100),
Address oAddress)
nested table Address store as tbAddress;
insert into people values (1,'Saikat Basak',
oAddress(objAddress('100','East West
Street','Kolkata','WB','700005')))