/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 vote319 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
1 vote284 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
6 votes357 views3 answers
What is where in sql
SQL
2 votes282 views1 answer
Oracle sql day of month from date
SQL
0 vote307 views1 answer
Mysql db dump restore max file size issue
SQL
1 vote274 views1 answer
Trigger in postgresql to change incoming entry
SQL
0 vote295 views1 answer
Cross apply top for each row t1
SQL
0 vote295 views1 answer
Sql delete from with relation
SQL
1 vote274 views1 answer
Sql get missing id
SQL
0 vote280 views1 answer
Display first three characters sql
SQL