create or replace type final as object ( ename1 varchar2(10), sal1
NUMBER(7,2));--object

create or replace type construct is table  of final; /*nested table of
object*/ type

create or replace function returnmore (empno1 number) /*Function to
return more*/
return construct
AS
vemp construct:=construct();
vename varchar2(10);
vsal1 NUMBER(7,2);
begin

select ENAME,sal into vename,vsal1 from emp where empno=empno1;
vemp.extend;
vemp(1):=construct(vename,vsal1);
return vemp;
end;