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,
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