<id column="ID" property="id" jdbcType="VARCHAR" />
<result column="ASSETS_IP" property="assetsIp" jdbcType="VARCHAR" />
<result column="TAG_NO" property="tagNo" jdbcType="VARCHAR" />
<result column="BEGIN_IP_NUM" property="beginIpNum" jdbcType="DECIMAL" />
<result column="END_IP_NUM" property="endIpNum" jdbcType="DECIMAL" />
<result column="CREATED_BY" property="createdBy" jdbcType="VARCHAR" />
<result column="CREATED_DATE" property="createdDate" jdbcType="DATE" />
<result column="LAST_UPDATED_BY" property="lastUpdatedBy" jdbcType="DECIMAL" />
<result column="LAST_UPDATED_DATE" property="lastUpdatedDate" jdbcType="DATE" />
<result column="ENABLED_FLAG" property="enabledFlag" jdbcType="VARCHAR" />
begin
INSERT INTO SOC_ADMIN.SOC_IP_TAG
(
ID,
ASSETS_IP,
TAG_NO,
BEGIN_IP_NUM,
END_IP_NUM,
CREATED_BY,
CREATED_DATE,
LAST_UPDATED_BY,
LAST_UPDATED_DATE,
ENABLED_FLAG
)
values(
#{item.id,jdbcType=VARCHAR}
,#{item.assetsIp,jdbcType=VARCHAR}
,#{item.tagNo,jdbcType=DECIMAL}
,#{item.beginIpNum,jdbcType=VARCHAR}
,#{item.endIpNum,jdbcType=DECIMAL}
,#{item.createdBy,jdbcType=VARCHAR}
,sysdate
,#{item.lastUpdatedBy,jdbcType=VARCHAR}
,sysdate
,#{item.enabledFlag,jdbcType=VARCHAR}
);
end;
delete from soc_admin.SOC_IP_TAG where tag_no = #{type}
select t3.*, RN from (
select t2.*,rownum RN from (
select ID, ASSETS_IP, TAG_NO, BEGIN_IP_NUM, END_IP_NUM from soc_admin.SOC_IP_TAG
)t2
WHERE 1=1
<if test="endRow > 0"> <![CDATA[AND rownum <= #{endRow}]]> </if>)t3
where 1=1
<if test="startRow > 0"> <![CDATA[AND RN >= #{startRow}]]> </if>
select count(1) from soc_admin.SOC_IP_TAG
select
t.ID,
t.ASSETS_IP,
t.TAG_NO,
t.BEGIN_IP_NUM,
t.END_IP_NUM,
t.CREATED_BY,
t.CREATED_DATE,
t.LAST_UPDATED_BY,
t.LAST_UPDATED_DATE,
t.ENABLED_FLAG
from soc_admin.soc_ip_tag t
where t.enabled_flag ='T'
=#{ipnum,jdbcType=BIGINT} ]]>
