merge into g_prjn
using (select * from "aaaaa" ) aaaaa
on (g_prjn.pnNo = aaaaa.pnNo)
when matched then
update set g_prjn.BUDGET=aaaaa.BUDGETAMOUNTCNY ,g_prjn.SYAMOUNT=aaaaa.BUDGETAMOUNTCNY,g_prjn.TOTALANCOUNT=aaaaa.COUNT
oracle查询名称为aaaaa的数据 时 需要将aaaaa用双引号,否则会报找不到表或视图的错误。