top of page
Search

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;




 
 
 

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...

 
 
 
Foreign key constraint violation

/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id...

 
 
 

Comments


bottom of page