|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
DROP SEQUENCE to UPDATE, 20 of 27
SAVEPOINT statement to identify a point in a transaction to which you can later roll back.
Specify the name of the savepoint to be created.
Savepoint names must be distinct within a given transaction. If you create a second savepoint with the same identifier as an earlier savepoint, the earlier savepoint is erased. After a savepoint has been created, you can either continue processing, commit your work, roll back the entire transaction, or roll back to the savepoint.
clark's salary, check that the total company salary does not exceed 27,000, then reenter clark's salary, enter: