select * from CH_OPDC_MAIN main where FD_PROCESS_TYPE is null [ and FD_GROUP in (SELECT REGEXP_SUBSTR('{FDGROUP}', '[^;]+', 1, LEVEL) FROM DUAL CONNECT BY REGEXP_SUBSTR( '{FDGROUP}', '[^;]+', 1, LEVEL) IS NOT NULL) ] [ and FD_WORK_CARD_NUM = '{FDWORKCARDNUM}']
希望匹配的结果是:
[ and FD_GROUP in (SELECT REGEXP_SUBSTR('{FDGROUP}', '[^;]+', 1, LEVEL) FROM DUAL CONNECT BY REGEXP_SUBSTR( '{FDGROUP}', '[^;]+', 1, LEVEL) IS NOT NULL) ]
[ and FD_WORK_CARD_NUM = '{FDWORKCARDNUM}']