I have a select as below
select empid,ename, salary, address1, address2, country, zip from emp;
using the above select I want to insert data into nested table. how can I do it ?
create table emp_dtl(
empid,
ename,
salary,
emp_address emp_addr)
Nested table emp_address store as empaddr_tab;
create type emp_address as object
(
address1,
address2,
country,
zip)
create type emp_addr is table of emp_address;