update ims_md_annotation_descrip set descrip_l = :descrip_l, descrip_s = :descrip_s where ims_md_an_de_id = :ims_md_an_de_id insert into ims_md_annotation_descrip (ims_md_an_de_id, ims_md_an_id, descrip_l, descrip_s) values (:ims_md_an_de_id, :ims_md_an_id, :descrip_l, :descrip_s) select '(' || ande.descrip_l || ') ' || ande.descrip_s as desc, ande.ims_md_an_de_id, an.ims_md_an_id, an.ims_md_id from ims_md_annotation_descrip ande, ims_md_annotation an where ande.ims_md_an_id = an.ims_md_an_id and ande.ims_md_an_id = :ims_md_an_id select * from ims_md_annotation_descrip where ims_md_an_de_id = :ims_md_an_de_id and ims_md_an_id = :ims_md_an_id