select ims_md_id
from ims_md_technical
where ims_md_id = :ims_md_id
update ims_md_technical
set otr_plt_l = :otr_plt_l,
otr_plt_s = :otr_plt_s
where ims_md_id = :ims_md_id
insert into ims_md_technical
(ims_md_id, otr_plt_l, otr_plt_s)
values
(:ims_md_id, :otr_plt_l, :otr_plt_s)
select '(' || otr_plt_l || ')' || ' ' || otr_plt_s as otr_plt, ims_md_id
from ims_md_technical
where ims_md_id = :ims_md_id