select * from ims_md_life_cycle_contrib lfc, ims_md_life_cycle_contrib_enty lfce where lfc.ims_md_lf_cont_id = :ims_md_lf_cont_id and lfc.ims_md_id = :ims_md_id and lfce.ims_md_lf_cont_id = :ims_md_lf_cont_id update ims_md_life_cycle_contrib set role_v = :role_v, role_s = :role_s, cont_date = :cont_date, cont_date_l = :cont_date_l, cont_date_s = :cont_date_s where ims_md_lf_cont_id = :ims_md_lf_cont_id update ims_md_life_cycle_contrib_enty set entity = :entity where ims_md_lf_cont_id = :ims_md_lf_cont_id insert into ims_md_life_cycle_contrib (ims_md_lf_cont_id, ims_md_id, role_s, role_v, cont_date, cont_date_l, cont_date_s) values (:ims_md_lf_cont_id, :ims_md_id, :role_s, :role_v, :cont_date, :cont_date_l, :cont_date_s) insert into ims_md_life_cycle_contrib_enty (ims_md_lf_cont_enti_id, ims_md_lf_cont_id, entity) values (:ims_md_lf_cont_enti_id, :ims_md_lf_cont_id, :entity) select lfc.role_v, lfc.role_s, lfce.entity, lfc.cont_date, lfc.cont_date_l, lfc.cont_date_s, lfc.ims_md_lf_cont_id, lfc.ims_md_id from ims_md_life_cycle_contrib lfc, ims_md_life_cycle_contrib_enty lfce where lfc.ims_md_lf_cont_id = lfce.ims_md_lf_cont_id and lfc.ims_md_id = :ims_md_id