PRIV_ID,
ROLE_ID
#{privId},
#{roleId}
and ROLE_ID = #{roleId}
insert into GW_SYS_REL_ROLE_PRIV(
)
values (
)
delete from GW_SYS_REL_ROLE_PRIV where ID = #{id}
delete from GW_SYS_REL_ROLE_PRIV
update GW_SYS_REL_ROLE_PRIV set flag_valid = 0 where>ID = #{id}
update GW_SYS_REL_ROLE_PRIV
ROLE_ID = #{roleId},ID = #{id}
update GW_SYS_REL_ROLE_PRIV
ROLE_ID = #{roleId},
delete from GW_SYS_REL_ROLE_PRIV WHERE
(ROLE_ID=#{rolePrivParam.roleId} AND
PRIV_ID=#{rolePrivParam.privId})
insert into GW_SYS_REL_ROLE_PRIV(
)
SELECT A.* FROM (
SELECT #{rolePrivParam.privId} PRIV_ID,
#{rolePrivParam.roleId} ROLE_ID
FROM DUAL
) A