Oracle PL/SQL | Object Pipelined Function Example

-- Creating Object Type
create or replace type object01 as Object(
field01 varchar2(10),
field02 varchar2(50),
field03 Address01
);
-- Creating Table of Object Type
create or replace type TableObject01 as table of Object01;
-- Defination Of Piplined Function using Object
create or replace function function01(vi_count in Number)
return TableObject01 pipelined
is
vs_row object01 := Object01('0', '0', Address01( '0', '0', '0', '0'));
begin
for i in 1 .. vi_count
loop
vs_row.field01 := to_char( i, '0000' );
vs_row.field02 := 'Name ' || to_char( i, '00' );
vs_row.field03 := Address01(
'Block ' || to_char( i, '00' ),
'Street' || to_char( i, '00' ),
'City' || to_char( i, '00' ),
'Country' || to_char( i, '00' ) || ' - 000 ' || to_char( i, '000' )
);
pipe row ( vs_row );
end loop;
end function01;
/
-- Using Pipelined Function.
select * from table( function01( 99 ) )