fn_gheck_str_match_result

CREATE OR REPLACE FUNCTION fn_gheck_str_match_result(STR_IN IN VARCHAR,PATTERN_IN IN VARCHAR)
 RETURNS BOOLEAN
 LANGUAGE plpgsql
 NOT FENCED NOT SHIPPABLE
AS $$ DECLARE 



	RESULT BOOLEAN := FALSE;
	MATCH_VALUES VARCHAR2(6000);
BEGIN
	MATCH_VALUES := REPLACE(PATTERN_IN, ';', ',');
	
	FOR STR IN (SELECT REGEXP_SUBSTR(MATCH_VALUES, '[^,]+', 1, LEVEL) AS SINGLE_VALUE
                FROM SYS_DUMMY
                CONNECT BY REGEXP_SUBSTR(MATCH_VALUES, '[^,]+', 1, LEVEL) IS NOT NULL)
    LOOP
        IF STR_IN LIKE REPLACE(STR.SINGLE_VALUE, '*', '%') THEN
            RESULT := TRUE;
            EXIT;  -- 如果找到匹配的值，立即退出循环
        END IF;
    END LOOP;

	RETURN RESULT ;
END$$
/