Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 6 of 6
To identify a point in a transaction to which you can later roll back.
See Also:
|
None.
To update BLAKE
's and CLARK
's salary, check that the total company salary does not exceed 27,000, then reenter CLARK
's salary, enter:
UPDATE emp SET sal = 2000 WHERE ename = 'BLAKE'; SAVEPOINT blake_sal; UPDATE emp SET sal = 1500 WHERE ename = 'CLARK'; SAVEPOINT clark_sal; SELECT SUM(sal) FROM emp; ROLLBACK TO SAVEPOINT blake_sal; UPDATE emp SET sal = 1200 WHERE ename = 'CLARK'; COMMIT;
|
Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|