SQL> select * from t1;
A B
---------- ----------
1 1
2 2
3 3
4 4
SQL> select * from t2;
C D
---------- ----------
1 2
3 4
SQL> merge into t1 using t2 on (t1.a=t2.c) when matched then update set t1.b=t2.
d;
2 行已合并。
SQL> roll;
回退已完成。
SQL> merge into t1 using t2 on (t1.a=t2.c) when matched then update set t1.a=t2.
c;
merge into t1 using t2 on (t1.a=t2.c) when matched then update set t1.a=t2.c
*
第 1 行出现错误:
ORA-38104: 无法更新 ON 子句中引用的列: "T1"."A"
ORA-38104: 无法更新 ON 子句中引用的列: "T1"."A"
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL>
9i当中对此错误的提示是:
ORA-30926: 无法在源表中获得一组稳定的行
10g当中变为:
ORA-38104: 无法更新 ON 子句中引用的列: "T1"."A",显然这是10g当中对此错误提示的一个改进,使我们能够迅速定位到错误点。
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/76846/viewspace-978158/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/76846/viewspace-978158/