top of page
Search
Writer's picturemdvorkin

Pipelined Function

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;




2 views0 comments

Recent Posts

See All

Get DDL for Oracle object

set feed off set long 1000000 set longchunksize 1000000 set pages 0 set lines 32767 set trimspool on set feed off set wrap on set...

Comments


bottom of page