/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 vote132 views1 answer
Sql server synonym
SQL
3 votes119 views2 answers
Postgresql remove not null constraint
SQL
0 vote110 views1 answer
Sqlite3 now
SQL
3 votes116 views3 answers
Mysql order by list
SQL
2 votes118 views2 answers
Compare date mysql
SQL
0 vote123 views1 answer
Every Derived yable must have its own alias
SQL
0 vote129 views4 answers
How to connect form to database
SQL
0 vote107 views1 answer
Postgresql regular expression special characters
SQL
14 votes138 views6 answers
Finding duplicate rows mysql
SQL
0 vote117 views1 answer
Minecraft duping allowed servers
SQL