Pipelined Function
- mdvorkin
- Nov 19, 2020
- 1 min read
create type int_set as table of integer;
/
create or replace function numerator return int_set pipelined is
i integer := 0;
begin
i := 0;
loop
pipe row(i);
i := i + 1;
end loop;
end;
/
select column_value from table(numerator) where rownum <= 10;
Comments