Oracle高手进！！！！！

Question

现有两个表 
table1：
POLICYNO                       SERIALNO INSUREDVISASERIALNO
---------------------- ---------------- ------------------------------
PECD201146010213000013                1 
PECD201146010213000013                2 
PECD201146010213000013                3 table2：
VISASERIALNO                                       BUSINESSNO
-------------------------------------------------- ------------------------------
3000008400581310                                   PECD201146010213000013-000001
3000008400581311                                   PECD201146010213000013-000002
3000008400581312                                   PECD201146010213000013-000003现在要讲table2中VISASERIALNO字段提取到table1的INSUREDVISASERIALNO字段，
两个表关联：是根据table2的BUSINESSNO字段对应table1的 POLICYNO+SERIALNO 字段急！                              

Answer 1

update table1 t1 set t1.INSUREDVISASERIALNO=t2.VISASERIALNO where t2.BUSINESSNO=(t1.POLICYNO||t1.SERIALNO);===
楼主拿去试试看

Answer 2

不知道这样行不行，试试看吧
update table1 a 
set a.INSUREDVISASERIALNO = (select VISASERIALNO from table2 
                              where BUSINESSNO = a.POLICYNO | '-' | to_char(a.SERIALNO, '000000'))

Answer 3

update table1 t1, table2 t2
set t1.INSUREDVISASERIALNO=t2.VISASERIALNO 
where t2.BUSINESSNO=(t1.POLICYNO||'-'||lpad(t1.SERIALNO,6,'0'))

Answer 4

http://www.cnblogs.com/tracy/archive/2010/04/16/1713607.html去看看吧。。一样的问题