select * from ims_md_life_cycle_contrib lfc, ims_md_life_cycle_contrib_entity 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_entity 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_entity (ims_md_lf_cont_enti_id, ims_md_lf_cont_id, entity) values (nextval('ims_md_life_cycle_contrib_entity_seq'), :ims_md_lf_cont_id, :entity)" select lfc.role_v || ' ' || '(' || lfc.role_s || ')' as role, lfce.entity, lfc.cont_date, '(' || lfc.cont_date_l || ')' || ' ' || lfc.cont_date_s as cont_date_ls, lfc.ims_md_lf_cont_id, lfc.ims_md_id from ims_md_life_cycle_contrib lfc, ims_md_life_cycle_contrib_entity lfce where lfc.ims_md_lf_cont_id = lfce.ims_md_lf_cont_id and lfc.ims_md_id = :ims_md_id