select *
from ims_md_metadata_scheme
where ims_md_md_sch_id = :ims_md_md_sch_id
and ims_md_id = :ims_md_id
update ims_md_metadata_scheme
set scheme = :scheme
where ims_md_md_sch_id = :ims_md_md_sch_id
insert into ims_md_metadata_scheme
(ims_md_md_sch_id, ims_md_id, scheme)
values
(:ims_md_md_sch_id, :ims_md_id, :scheme)
select scheme, ims_md_id, ims_md_md_sch_id, scheme
from ims_md_metadata_scheme
where ims_md_id = :ims_md_id