Databases Reference
In-Depth Information
2.
Update a row on the
CUSTOMERS
table in
SESSION
1
:
UPDATE CUSTOMERS SET
CUST_FIRST_NAME = 'TEST1-1'
WHERE CUST_ID = 26;
3.
Connect
SESSION
2
to the database as
SH
user:
-- SESSION 2
CONNECT sh@TESTDB/sh
4.
Update a row on the
CUSTOMERS
table in
SESSION
2
, different from the one
updated in step 2 by
SESSION
1
:
UPDATE CUSTOMERS SET
CUST_FIRST_NAME = 'TEST2-1'
WHERE CUST_ID = 30;
5.
Try to update, in
SESSION
1
, the same row updated in step 4 by
SESSION
2
:
-- SESSION 1
UPDATE CUSTOMERS SET
CUST_FIRST_NAME = 'TEST1-2'
WHERE CUST_ID = 30;
6.
Try to update, in
SESSION
2
, the same row updated in step 2 by
SESSION
1
:
-- SESSION 2
UPDATE CUSTOMERS SET
CUST_FIRST_NAME = 'TEST2-2'
WHERE CUST_ID = 26;
7.
Rollback transaction in
SESSION
1
:
-- SESSION 1
ROLLBACK;
8.
Rollback transaction in
SESSION
2
:
-- SESSION 2
ROLLBACK;
9.
Connect to the database as
SYSDBA
:
-- SESSION 3
CONNECT / AS SYSDBA