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 영구 무료 라이선스 제공

jdbc 오류

javasp start fail이 발생합니다.

자연조인문제

killtran 관련하여 문의 드립니다.

Cubrid 물리명 길이 제한 값이 어떻게되나요?

쿼리속도문제

dbtimezone

데이터베이스 삭제시 incorrect or missing password

재귀절을 이용한 뷰 생성

데이터타입 조회 문의

cannot communicate with the broker or received invalid packet

Docker

비밀번호 변경 오류

큐브리드 DB 복원 관련 문의

큐브리드 매니저 테이블 목록 표시 관련해서 질문이 있습니다

cubrid에 세션확인 방법

테이블 코멘트 컬럼 코멘트 질문

다중 IN(튜플 IN)이 1건인 경우 오류 발생됩니다 큐브리드 자체문제이지 않나 싶어 문의드립니다

GRANT SELECT 후 SELECT 쿼리 실행 오류 문의

auto commit 이 되어있어서 잘못 update 처리한 데이터가 commit 되었을 때 대처법 부탁드립니다

Contact Cubrid

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

Site Map