select ims_md_id
from ims_md_rights
where ims_md_id = :ims_md_id
update ims_md_rights
set descrip_l = :descrip_l,
descrip_s = :descrip_s
where ims_md_id = :ims_md_id
insert into ims_md_rights
(ims_md_id, descrip_l, descrip_s)
values
(:ims_md_id, :descrip_l, :descrip_s) "
select '(' || descrip_l || ') ' || descrip_s as desc, ims_md_id
from ims_md_rights
where ims_md_id = :ims_md_id