INSERT INTO TBB01_HIS_SPEC(INTFE_ID , ACT_TP , ACT_SQL , WHERE_PARAM , REG_PGM_ID , REG_ID , REG_DTIME ) VALUES(? , ? ,? , ? , ? , ? , TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')) SELECT * FROM TBB01_HIS_SPEC T WHERE T.INTFE_ID LIKE ?||'%' AND SUBSTR(T.REG_DTIME ,1,8) BETWEEN ? AND ? ORDER BY T.REG_DTIME SELECT T.MNSCR_ID VALUE , T.MNSCR_NM LABEL FROM TBZ01_MNSCR T WHERE T.MNSCR_ID LIKE 'UIB01%' AND T.MNSCR_ID NOT IN('UIB016000' , 'UIB016000' , 'UIB010120' , 'UIB010020' , 'UIB010340' , 'UIB015100' , 'UIB010060' , 'UIB015110' , 'UIB015020') AND T.UPCHECK_YN = 'Y' ORDER BY T.MNSCR_ID