--根据分隔符返回分隔的组数
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+