Orcale 增删改查sql

Insert>B表关联A表，获取A表信息，插入C表
Insert
into table_c
(
td_ac_id, td_name)
select a.td_ac_id, a.td_name from table_a a ,table_b b
where a.td_ac_id = b.td_ac_id and b.process_result=3 ;

Update>T表关联E表，E表中字段p_date值赋值给字段v_date，字段p_date值的n个月（例如t_num为M12D0,则为取12个月）后赋值给字段m_date
update table_e e
set e.v_date =e.p_date,
e.m_date =( to_char( add_months( to_date(e.p_date,‘yyyymmdd’),substr(e.term_num,2,2)),‘YYYYMMDD’))
where e.td_ac_id =
(select td_ac_id
from table_t t
where t.p_result=‘3’
);

Update>A表关联T表，获取T表中字段c_bal赋值U表b_bal
UPDATE table_U u
SET u.b_bal =
(SELECT c.c_bal
FROM
(SELECT a.t_id ,
t.c_bal
FROM table_A a ,
table_T t
WHERE a.t_id =t._id
AND a.p_result=‘异常’
) c
)
WHERE EXISTS
(SELECT c.t_id
FROM
(SELECT a.t_id ,
t.c_bal
FROM table_A a ,
table_T t
WHERE a.t_id =t.t_id
AND a.p_result=‘异常’
) c
WHERE u.t_id=c.t_id
);