oracle의 for in loop를 mssql로

Question

--ORACLE PROCEDURE 영역 v_cnt NUMBER; FOR data IN (SELECT REGEXP_SUBSTR(T1.SPLIT_VALUE, '(.*?)(:|$)', 1, 1, NULL, 1) AS AA ,REGEXP_SUBSTR(T1.SPLIT_VALUE, '(.*?)(:|$)', 1, 2, NULL, 1) AS BB ,REGEXP_SUBSTR(T1.SPLIT_VALUE, '(.*?)(:|$)', 1, 3, NULL, 1) AS CC ,REGEXP_SUBSTR(T1.SPLIT_VALUE, '(.*?)(:|$)', 1, 4, NULL, 1) AS DD ,REGEXP_SUBSTR(T1.SPLIT_VALUE, '(.*?)(:|$)', 1, 5, NULL, 1) AS EE FROM TABLE(FN_SPLIT(t_data, '|')) T1) LOOP SELECT COUNT(*) INTO v_cnt FROM TB_TEST TBS WHERE TBS.BB &#61; data.BB AND TBS.CC &#61; data.CC AND TBS.DD &#61; data.DD; &#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61; 위와같은 오라클의 프로시져를 MSSQL로 바꾸려고 하는데 너무나 어렵네요.... 어떻게 해야할까요?

oracle의 for in loop를 mssql로

0개의 답변

Q&A 목록