/SQL/Oracle transaction commit rollback example

Oracle transaction commit rollback example

-- Rollback (cancellation)
DELETE FROM employees WHERE employee_id = 123;    -- Done in current session
ROLLBACK;                                         -- Cancelled in current session
SELECT * FROM employees WHERE employee_id = 123;  -- Found
-- Commit (validation)
DELETE FROM employees WHERE employee_id = 123;    -- Done in current session
COMMIT;                                           -- Visible for ALL sessions
SELECT * FROM employees WHERE employee_id = 123;  -- Missing for ALL sessions

Source: oracle-dba-online.com

Similar codes

0 vote211 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote260 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote177 views1 answer
Sql constarint
SQL
4 votes205 views1 answer
Search column by name mysql
SQL
0 vote182 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote182 views1 answer
How to install sql in anaconda
SQL
3 votes208 views1 answer
Oracle undo tablespace schema
SQL
1 vote218 views1 answer
Mysql search like order by best match
SQL
1 vote187 views1 answer
Check message id sql server
SQL
13 votes181 views5 answers
Select last row mysql
SQL