/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 vote253 views1 answer
Create function in microsoft sql server
SQL
5 votes213 views1 answer
Oracle asynchronous update
SQL
0 vote262 views1 answer
Postgres get running query
SQL
0 vote218 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote284 views1 answer
Postgressql uuid
SQL
1 vote201 views1 answer
Oracle explain plan
SQL
0 vote190 views1 answer
Oracle 11g forget password
SQL
1 vote209 views2 answers
How to drop a unique constraint in sql
SQL
1 vote203 views1 answer
What is in condition in sql
SQL
0 vote216 views1 answer
Mysql get first 2 characters of string
SQL