ID, NM, OBJ_TYPE, IS_DEFAULT, INTM, UPTM, DATA_STAT #{id}, #{nm}, #{objType}, #{isDefault}, #{intm}, #{uptm}, #{dataStat} and NM LIKE '%${nm}%' and OBJ_TYPE = #{objType} and IS_DEFAULT = #{isDefault} and DATA_STAT='0' select from BIS_INSP_PBLM_P where ID = #{id} select from BIS_INSP_PBLM_P and NM = #{nm} and OBJ_TYPE = #{objType} and IS_DEFAULT = #{isDefault} and DATA_STAT='0' select from BIS_INSP_PBLM_P select from BIS_INSP_PBLM_P select count(ID) from BIS_INSP_PBLM_P insert into BIS_INSP_PBLM_P( ) values ( ) update BIS_INSP_PBLM_P set DATA_STAT='9' where ID = #{id} update BIS_INSP_PBLM_P set DATA_STAT='9' update BIS_INSP_PBLM_P set DATA_STAT = '9' where ID = #{id} update BIS_INSP_PBLM_P NM = #{nm}, OBJ_TYPE = #{objType}, IS_DEFAULT = #{isDefault}, INTM = #{intm}, UPTM = #{uptm}, DATA_STAT = #{dataStat}, ID = #{id} update BIS_INSP_PBLM_P NM = #{nm}, OBJ_TYPE = #{objType}, IS_DEFAULT = #{isDefault}, INTM = #{intm}, UPTM = #{uptm}, DATA_STAT = #{dataStat}, SELECT D.ID FROM BIS_INSP_GENRL_RGSTR A JOIN BIS_INSP_ALL_OBJ B ON A.OBJ_ID = B.OBJ_ID JOIN BIS_INSP_BASE_NEW C ON B.CODE = C.ID JOIN BIS_INSP_PBLM_P D ON C.OBJ_TYPE = D.OBJ_TYPE WHERE A.ID = #{rgstrId} AND D.DATA_STAT = '0' AND D.IS_DEFAULT = '1'