sql

sql

Using Collections of Packages Declared in the PL/SQL Specification in SQL Context

Question: It is necessary to insert values ​​into the table from the collection declared in the package. I create the following: create table t_test (col01 number, col02 number); create or replace package pack is type numtab is table of number; function getnt (arg numtab) return numtab pipelined; end pack; / …

Using Collections of Packages Declared in the PL/SQL Specification in SQL Context Read More »

sql – Create a function that turns a single CSV row into a table using a regular expression to find delimiters

Question: Please tell me how to change the following code : with temp as ( select 108 Name, ‘test’ Project, ‘string-1 , string-2 ; string-3’ Error from dual union all select 109, ‘test2’, ‘single string’ from dual ) select distinct t.name, t.project, trim(regexp_substr(t.error, ‘[^,;]+’, 1, levels.column_value)) as error from temp …

sql – Create a function that turns a single CSV row into a table using a regular expression to find delimiters Read More »

Scroll to Top