ORACLE实现字符串分割SPLIT

发布时间：2020-12-12 16:11:08 所属栏目：百科来源：网络整理

导读：CREATE OR REPLACE TYPE str_split_table IS TABLE OF VARCHAR2 (4000); CREATE OR REPLACE FUNCTION str_split(p_string IN VARCHAR2,p_delimiter IN VARCHAR2) RETURN str_split_table PIPELINED AS v_length NUMBER := LENGTH(p_string); v_start NUMBER :

CREATE OR REPLACE TYPE str_split_table IS TABLE OF VARCHAR2 (4000); CREATE OR REPLACE FUNCTION str_split(p_string IN VARCHAR2,p_delimiter IN VARCHAR2) RETURN str_split_table PIPELINED AS v_length NUMBER := LENGTH(p_string); v_start NUMBER := 1; v_index NUMBER; BEGIN WHILE(v_start <= v_length) LOOP v_index := INSTR(p_string,p_delimiter,v_start); IF v_index = 0 THEN PIPE ROW(SUBSTR(p_string,v_start)); v_start := v_length + 1; ELSE PIPE ROW(SUBSTR(p_string,v_start,v_index - v_start)); v_start := v_index + 1; END IF; END LOOP; RETURN; END str_split;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!