select ims_md_id
from ims_md_technical
where ims_md_id = :ims_md_id
update ims_md_technical
set instl_rmrks_l = :instl_rmrks_l,
instl_rmrks_s = :instl_rmrks_s
where ims_md_id = :ims_md_id"
insert into ims_md_technical
(ims_md_id, instl_rmrks_l, instl_rmrks_s)
values
(:ims_md_id, :instl_rmrks_l, :instl_rmrks_s)
select '(' || instl_rmrks_l || ')' || ' ' || instl_rmrks_s as instl_rmrks, ims_md_id
from ims_md_technical
where ims_md_id = :ims_md_id