INSERT INTO TBB02_COLD_OTHERS
(
PROD_SEQ
,PROD_LINE
,BAN_CI
,BAN_ZU
,STOP_DTIME
,START_DTIME
,SUM_
,EVNET_NM
,EDT_NM
,DEPART_NM
,REG_ID
,REG_DTIME
)
VALUES (TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'),?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))
UPDATE TBB02_COLD_OTHERS
SET PROD_LINE = ?
,BAN_CI = ?
,BAN_ZU = ?
,STOP_DTIME = ?
,START_DTIME = ?
,SUM_ = ?
,EVNET_NM = ?
,EDT_NM = ?
,DEPART_NM = ?
,MOD_ID = ?
,MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
WHERE PROD_SEQ = ?
DELETE FROM TBB02_COLD_OTHERS WHERE PROD_SEQ = ?