达梦数据库字符串切割-自定义函数

 

--根据分隔符返回分隔的组数

CREATE OR REPLACE 
        FUNCTION get_StrArrayLength(STR VARCHAR(2000),SPLIT1 VARCHAR(10)) 
                RETURN INT 
        AS 
                V_LOCATION INT; 
                V_START    INT; 
                V_LENGTH   INT; 
        BEGIN 
                STR:=LTRIM(RTRIM(STR)); 
                V_LOCATION :=LOCATE(SPLIT1,STR); 
                V_LENGTH  :=1; 
                WHILE V_LOCATION <>0 
                LOOP 
                        V_START:=V_LOCATION+