select ims_md_id
from ims_md_technical
where ims_md_id = :ims_md_id
update ims_md_technical
set duration_s = :duration_s, duration_l = :duration_l,
duration = :duration
where ims_md_id = :ims_md_id
insert into ims_md_technical (ims_md_id, duration_l, duration_s)
values
(:ims_md_id, :duration_l, :duration_s)
select duration_l, duration_s,
duration || 's' as duration_sec,
ims_md_id
from ims_md_technical
where ims_md_id = :ims_md_id