mdvorkinNov 19, 20201 min readPipelined Functioncreate 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;
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;
Get DDL for Oracle objectset feed off set long 1000000 set longchunksize 1000000 set pages 0 set lines 32767 set trimspool on set feed off set wrap on set...
Cancelled scheduled concurrent requestsThis SQL query returns all concurrent requests that were scheduled in the past and are not scheduled currently. It can be used for...
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