select *
from ims_md_relation_resource
where ims_md_re_re_id = :ims_md_re_re_id
and ims_md_re_id = :ims_md_re_id
update ims_md_relation_resource
set descrip_l = :descrip_l,
descrip_s = :descrip_s
where ims_md_re_re_id = :ims_md_re_re_id
select '(' || rere.descrip_l || ')' || ' ' || rere.descrip_s as descrip,
rere.ims_md_re_re_id, re.ims_md_re_id, re.ims_md_id
from ims_md_relation_resource rere, ims_md_relation re
where rere.ims_md_re_id = :ims_md_re_id
and re.ims_md_re_id = :ims_md_re_id