CREATEORREPLACEFUNCTIONfn_split (p_strINVARCHAR2, p_delimiterINVARCHAR2)RETURNty_str_split--分割函数--新建前要先建立ty_str_split 执行语句为:CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2 (4000);ISjINT:=0; iINT:=1;
功能描述:用指定分隔符切割输入的字符串,返回一维数组,每个数组元素为一个子串。 1CREATEORREPLACETYPE ty_str_splitISTABLEOFVARCHAR2(4000);23CREATEORREPLACEFUNCTIONfn_split (p_strINVARCHAR2, p_delimiterINVARCHAR2)4RETURNty_str_split5IS6jINT:=0;7iINT:=1;8lenINT:=0;9len1INT:=0;10strVARCHAR2(...
1. Row 类型 CREATEORREPLACETYPE ty_row_str_splitasobject (strValueVARCHAR2(4000)) 2. Table 类型 CREATEORREPLACETYPE ty_tbl_str_splitISTABLEOFty_row_str_split 创建函数: CREATEORREPLACEFUNCTIONfn_split(p_strINVARCHAR2, p_delimiterINVARCHAR2) RETURNty_tbl_str_splitIS jINT:=0; iINT:=1; ...
len1 INT := 0; str VARCHAR2 (4000); str_split ty_str_split := ty_str_split (); BEGIN len := LENGTH (p_str); len1 := LENGTH (p_delimiter); WHILE j < len LOOP j := INSTR (p_str, p_delimiter, i); IF j = 0 THEN j := len; str := SUBSTR (p_str, i); str_spli...
oracle的split函数截取如何返回成一行数据 CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2 (4000);CREATE OR REPLACE FUNCTION split (p_str IN VARCHAR2, p_delimiter IN VARCHAR2)RETURN ty_str_split IS j INT := 0;i INT := 1;len INT := 0;len1 INT := 0;str ...
CREATE OR REPLACE TYPE ty_str_split AS TABLE OF VARCHAR2(400); CREATE OR REPLACE FUNCTION fn_split(p_str IN VARCHAR2, p_delimiter IN VARCHAR2) RETURN ty_str_split IS j INT := 0; i INT := 1; len INT := 0; len1 INT := 0; str VARCHAR2(400); str_split ty_str_split :=...
CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2(4000); ---2.创建一个分割的函数,主要对json进行按照固定割串分割 CREATE OR REPLACE FUNCTION fn_split (p_str IN VARCHAR2, p_delimiter IN VARCHAR2) RETURN ty_str_split IS j INT := 0; ...
Oracle中按规定的字符截取字符串CREATE OR REPLACE FUNCTION "F_SPLIT" (p_str IN CLOB, p_delimiter IN VARCHAR2)RETURN ty_str_split IS j INT :=0;i INT :=1;len INT :=0;len1 INT :=0;str VARCHAR2(4000);str_split ty_str_split := ty_str_split();BEGIN len := LENGTH(...
1.CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2 (4000); 2.CREATE OR REPLACE FUNCTION cux_pub_str_split (p_str IN VARCHAR2, p_delimiter IN VARCHAR2) RETURN ty_str_split PIPELINED IS j INT := 0; i INT := 1;
-- 方法一：函数切割--功能描述：用指定分隔符切割输入的字符串，返回一维数组，每个数组元素为一个子串。CREATE OR REPLACE FUNCTION fn_split (p_str IN VARCHAR2, p_delimiter IN VARCHAR2) RETURN ty_str_splitIS j INT := 0; i INT := 1; len INT := 0; len1 INT ...