select * from ims_md_technical_location where ims_md_te_lo_id = :ims_md_te_lo_id and ims_md_id = :ims_md_id update ims_md_technical_location set type = :type, location = :location where ims_md_te_lo_id = :ims_md_te_lo_id insert into ims_md_technical_location (ims_md_te_lo_id, ims_md_id, type, location) values (:ims_md_te_lo_id, :ims_md_id, :type, :location) select type, location, ims_md_te_lo_id, ims_md_id from ims_md_technical_location where ims_md_id = :ims_md_id