update ims_md_educational_tar
set tar_l = :tar_l,
tar_s = :tar_s
where ims_md_ed_ta_id = :ims_md_ed_ta_id
insert into ims_md_educational_tar
(ims_md_ed_ta_id, ims_md_id, tar_l, tar_s)
values
(:ims_md_ed_ta_id, :ims_md_id, :tar_l, :tar_s)
select *
from ims_md_educational_tar
where ims_md_ed_ta_id = :ims_md_ed_ta_id
and ims_md_id = :ims_md_id
select '(' || tar_l || ') ' || tar_s as tar, ims_md_ed_ta_id, ims_md_id
from ims_md_educational_tar
where ims_md_id = :ims_md_id