CUBRID | Q&A - merge 쿼리 속도개선

* 질문 등록 시 다음의 내용을 꼭 기입하여 주세요.

OS	Window7 32bit, Linux 64bit 등
CUBRID Ver.	[cubrid_rel] 수행 결과
CUBRID TOOL Ver.	[도움말]-[버전정보] 확인
응용 환경(API)	java, php, odbc 등 입력

* CUBRID 응용 오류, SQL 오류 또는 SQL 튜닝 관련된 문의는 반드시 다음의 내용을 추가해 주세요. 비밀글이나 비밀 댓글도 가능합니다.
* 저희가 상황을 이해하고, 재현이 가능해야 알 수 있는 문제들이 많습니다. 가능한 정보/정황들을 부탁합니다.

에러 내용 및 재현 방법	재현 가능한 Source와 SQL
관련 테이블(인덱스, 키정보 포함) 정보	CUBRID 홈 디렉토리 아래 log 디렉토리 압축

-------------- 아래에 질문 사항을 기입해 주세요. ------------------------------------------------------------------------

merge into 쿼리문 입니다. 약 340건 조회 후 insert update시 시간이 30초 이상 걸리는거같은데 속도개선 방법좀 알고 싶어 문의 드립니다.

340건 조회하는데 12초정도 걸리고 나머지는 insert, update에서 걸리는 시간인 것 같습니다.

console에 실행된 쿼리

/* ck-input.tempSaveCkInput */
MERGE INTO ESFCCKSR x
USING (SELECT a.SYS_ID
,a.CKDR_NO /* 점검지시서번호 */
,a.CK_NO /* 점검번호 */
,b.OBJ_SN /* 오브젝트 일련번호 */
,c.CK_FACT_SN /* 점검항목 일련번호 */
,a.MOD_LOG_CNT /* 수정이력 회차 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN NVL(d.ACT_YN_CD, 'Y')
ELSE e.ACT_YN_CD
END ACT_YN_CD /* 실행여부 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN NVL(d.CK_RES, 'P010')
ELSE e.CK_RES
END CK_RES /* 점검결과 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN d.CK_VAL
ELSE e.CK_VAL
END CK_VAL /* 점검값 */
,e.CK_REM /* 비고 추가 */
,c.NUM_INPUT_YN
,'AURI07' CURR_ID
,'2023-05-23 09:28:08.562' CURR_DT
FROM ESFCCKSC a
INNER JOIN ESFCCKOB b
ON b.SYS_ID = a.SYS_ID
AND b.CK_NO = a.CK_NO
AND b.MOD_LOG_CNT = a.MOD_LOG_CNT
AND b.STS IN ('C', 'U')
INNER JOIN ESFCCKDT c
ON c.SYS_ID = a.SYS_ID
AND c.CK_NO = a.CK_NO
AND c.MOD_LOG_CNT = a.MOD_LOG_CNT
AND c.ORGN_YN = 'Y'
AND c.STS IN ('C', 'U')
LEFT OUTER JOIN ESFCCKSR d
ON d.SYS_ID = a.SYS_ID
AND d.CK_NO = a.CK_NO
AND d.CKDR_NO = a.CKDR_NO
AND d.MOD_LOG_CNT = a.MOD_LOG_CNT
AND d.OBJ_SN = b.OBJ_SN
AND d.CK_FACT_SN = c.CK_FACT_SN
LEFT OUTER JOIN (

SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183447' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183447' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT

) e
ON e.CK_NO = c.CK_NO
AND e.CKDR_NO = a.CKDR_NO
AND e.MOD_LOG_CNT = c.MOD_LOG_CNT
AND e.OBJ_SN = b.OBJ_SN
AND e.CK_FACT_SN = c.CK_FACT_SN
WHERE a.SYS_ID = 'IIAC'
AND a.CKDR_NO = '40789385') y
ON (x.SYS_ID = y.SYS_ID AND x.CK_NO = y.CK_NO AND x.CKDR_NO = y.CKDR_NO AND x.MOD_LOG_CNT = y.MOD_LOG_CNT AND x.OBJ_SN = y.OBJ_SN AND x.CK_FACT_SN = y.CK_FACT_SN)
WHEN MATCHED THEN
UPDATE
SET x.ACT_YN_CD = y.ACT_YN_CD
,x.CK_RES = y.CK_RES
,x.CK_VAL = y.CK_VAL
,x.rem = y.CK_REM /* 비고추가 */
,x.STS = 'U'
,x.MOD_ID = y.CURR_ID
,x.MOD_DT = y.CURR_DT
WHEN NOT MATCHED THEN
INSERT(x.SYS_ID
,x.CK_NO
,x.CKDR_NO
,x.OBJ_SN
,x.CK_FACT_SN
,x.MOD_LOG_CNT
,x.ACT_YN_CD
,x.CK_RES
,x.CK_VAL
,x.rem /* 비고추가 */
,x.STS
,x.REG_ID
,x.REG_DT)
VALUES(y.SYS_ID
,y.CK_NO
,y.CKDR_NO
,y.OBJ_SN
,y.CK_FACT_SN
,y.MOD_LOG_CNT
,y.ACT_YN_CD
,y.CK_RES
,y.CK_VAL
,y.CK_REM /* 비고추가 */
,'C'
,y.CURR_ID
,y.CURR_DT)

--------------------------------------------------------------------------------------------------------------

xml 쿼리문

<update id="tempSaveCkInput">
/* ck-input.tempSaveCkInput */
MERGE INTO ESFCCKSR x
USING (SELECT a.SYS_ID
,a.CKDR_NO /* 점검지시서번호 */
,a.CK_NO /* 점검번호 */
,b.OBJ_SN /* 오브젝트 일련번호 */
,c.CK_FACT_SN /* 점검항목 일련번호 */
,a.MOD_LOG_CNT /* 수정이력 회차 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN NVL(d.ACT_YN_CD, 'Y')
ELSE e.ACT_YN_CD
END ACT_YN_CD /* 실행여부 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN NVL(d.CK_RES, 'P010')
ELSE e.CK_RES
END CK_RES /* 점검결과 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN d.CK_VAL
ELSE e.CK_VAL
END CK_VAL /* 점검값 */
,e.CK_REM /* 비고 추가 */
,c.NUM_INPUT_YN
,#{g.username} CURR_ID
,#{g.now} CURR_DT
FROM ESFCCKSC a
INNER JOIN ESFCCKOB b
ON b.SYS_ID = a.SYS_ID
AND b.CK_NO = a.CK_NO
AND b.MOD_LOG_CNT = a.MOD_LOG_CNT
AND b.STS IN ('C', 'U')
INNER JOIN ESFCCKDT c
ON c.SYS_ID = a.SYS_ID
AND c.CK_NO = a.CK_NO
AND c.MOD_LOG_CNT = a.MOD_LOG_CNT
AND c.ORGN_YN = 'Y'
AND c.STS IN ('C', 'U')
LEFT OUTER JOIN ESFCCKSR d
ON d.SYS_ID = a.SYS_ID
AND d.CK_NO = a.CK_NO
AND d.CKDR_NO = a.CKDR_NO
AND d.MOD_LOG_CNT = a.MOD_LOG_CNT
AND d.OBJ_SN = b.OBJ_SN
AND d.CK_FACT_SN = c.CK_FACT_SN
LEFT OUTER JOIN (
<choose>
<when test='p.updateList2 != null and p.updateList2.size() != 0'>
<foreach collection="p.updateList2" item="item" separator="UNION ALL" open="" close="">
SELECT #{item.ckdr_no} CKDR_NO
,#{item.obj_sn} OBJ_SN
,#{item.ck_fact_sn} CK_FACT_SN
,#{item.mod_log_cnt} MOD_LOG_CNT
,#{item.ck_no} CK_NO
,#{item.act_yn_cd} ACT_YN_CD
,#{item.ck_res} CK_RES
,CASE WHEN #{item.ck_val} IS NULL THEN NULL ELSE CAST(#{item.ck_val} AS NUMERIC(20, 2)) END CK_VAL
,#{item.ck_rem} CK_REM /* 비고추가 */
FROM DB_ROOT
</foreach>
</when>
<otherwise>
SELECT NULL CKDR_NO
,NULL OBJ_SN
,NULL CK_FACT_SN
,NULL MOD_LOG_CNT
,NULL CK_NO
,NULL ACT_YN_CD
,NULL CK_RES
,NULL CK_VAL
,NULL CK_REM
FROM DB_ROOT
</otherwise>
</choose>
) e
ON e.CK_NO = c.CK_NO
AND e.CKDR_NO = a.CKDR_NO
AND e.MOD_LOG_CNT = c.MOD_LOG_CNT
AND e.OBJ_SN = b.OBJ_SN
AND e.CK_FACT_SN = c.CK_FACT_SN
WHERE a.SYS_ID = #{g.tenant}
AND a.CKDR_NO = #{p.searchParam.select_ckdr_no}) y
ON (x.SYS_ID = y.SYS_ID AND x.CK_NO = y.CK_NO AND x.CKDR_NO = y.CKDR_NO AND x.MOD_LOG_CNT = y.MOD_LOG_CNT AND x.OBJ_SN = y.OBJ_SN AND x.CK_FACT_SN = y.CK_FACT_SN)
WHEN MATCHED THEN
UPDATE
SET x.ACT_YN_CD = y.ACT_YN_CD
,x.CK_RES = y.CK_RES
,x.CK_VAL = y.CK_VAL
,x.rem = y.CK_REM /* 비고추가 */
,x.STS = 'U'
,x.MOD_ID = y.CURR_ID
,x.MOD_DT = y.CURR_DT
WHEN NOT MATCHED THEN
INSERT(x.SYS_ID
,x.CK_NO
,x.CKDR_NO
,x.OBJ_SN
,x.CK_FACT_SN
,x.MOD_LOG_CNT
,x.ACT_YN_CD
,x.CK_RES
,x.CK_VAL
,x.rem /* 비고추가 */
,x.STS
,x.REG_ID
,x.REG_DT)
VALUES(y.SYS_ID
,y.CK_NO
,y.CKDR_NO
,y.OBJ_SN
,y.CK_FACT_SN
,y.MOD_LOG_CNT
,y.ACT_YN_CD
,y.CK_RES
,y.CK_VAL
,y.CK_REM /* 비고추가 */
,'C'
,y.CURR_ID
,y.CURR_DT)
</update>

FORUM

merge 쿼리 속도개선

단축키

단축키

CUBRID 사용자를 위한 DBeaver 도구 출시 안내

SQLGate for CUBRID 영구 무료 라이선스 제공

Cubrid stored procedure 스케쥴 등록 형식

java stored procedure 에 loadjava 로 jar 파일 로드 시 java.lang.ClassNotFoundException 에러 문의

서버 메모리 교체 및 ha 상 데이터 삭제 절차

Fk값 가져오기

큐브리드 매니저 접속 이 안됩니다. 확인 요청 드립니다.

cubrid driver 설치 문의

하나의 쿼리에서 복수 테이블 업데이트 방법 문의

ddl 추출

큐브리드 매니저 실행이 오류

cci 프로그래밍에서 DB LINK 관련 문의

spring boot 에서 HikariPool-1 - Driver does not support get/set network timeout for connections. (java.lang.UnsupportedOperationException) 질문 드립니다.

쿼리 속도 차이 질문

8.4.4버젼 charset 확인

8.4.4 charset. Collation 확인 방법

데이터 이관 문의입니다.

브로커(CAS)수 질문드립니다!

merge 쿼리 속도개선

cubrid cursor.close() 에러 관련질문

NX_transcation

MERGE INTO 속도 개선 문의

Contact Cubrid

대표전화 070-4077-2110 / 기술문의 070-4077-2113 / 영업문의 070-4077-2112 / Email. contact_at_cubrid.com

Site Map