create or replace procedure test_msg 
AS 
L_EC TY_STR_SPLIT; 
The begin 
L_EC:=F_C_SPLITSTR (' Q | Q | E ', '|'); 

FOR I IN 1.. L_EC. COUNT LOOP 
Dbms_output. Put_line (L_EC (I)); 
END LOOP; 
end; 

TY_STR_SPLIT OF them CREATE OR REPLACE TYPE "TY_STR_SPLIT" IS the TABLE OF VARCHAR2 (4000)
I want to get rid of L_EC get repeated, Q, E collection, how to get in ORACLE

CodePudding user response:

Study the building Lord regexp_substr the function, the existing problems for you, very useful,