---
title: "oracle同个事务中更新两次，后一次依赖前一次会有什么后果呢"
author: "winzenghua"
date: "2009-11-05T11:57:00Z"
tags: []
slug: "oracle"
draft: false
lastmod: "2009-11-05T11:57:00Z"
id: 987835
url: "https://java4gis.iteye.com/blog/987835"
---

本来是想第二条更新根据前面更新的数据为依据，可这样前面的更新没提交，后面的会怎么样呢？　所以做个实验

SQL&gt; create table t\_tmp\_name (name varchar2(5),age number);  
Table created  
SQL&gt; insert into t\_tmp\_name values('x',25);  
1 row inserted  
SQL&gt; commit;  
Commit complete  
SQL&gt; update t\_tmp\_name set name='y' where name = 'x';  
1 row updated  
SQL&gt; select * from t\_tmp\_name ;  
NAME AGE  
\----- ----------  
y 25  
――接着继续根据新的值来更新  
SQL&gt; update t\_tmp\_name set age =90 where name ='y';  
1 row updated  
SQL&gt; select * from t\_tmp\_name;  
NAME AGE  
\----- ----------  
y 90

－－结果得到了更新  
――这时候不提交　开个Session2

SQL&gt; commit;  
Commit complete  
SQL&gt;

――Session 2  
SQL&gt; select * from t\_tmp\_name ;  
NAME AGE  
\----- ----------  
x 25

-- 这里看到还是老数据 这个数据应该是重UNDO表空间获得吧！

SQL&gt; update t\_tmp\_name set age=30 where name = 'x';

――这里一直等待SESSION 1的解锁  
0 rows updated  
SQL&gt;

![](http://hi.csdn.net/attachment/200910/27/59482_1256633773BOx9.jpg)