/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

7 votes141 views2 answers
MySQL IF without else
SQL
0 vote133 views1 answer
C# datetime to sql server datetime
SQL
1 vote141 views1 answer
Isnull sql server
SQL
0 vote126 views1 answer
Clone table structure mysql
SQL
2 votes133 views2 answers
Mysql all columns
SQL
0 vote147 views3 answers
Sql server import json
SQL
0 vote128 views1 answer
Update having mysql
SQL
0 vote153 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote166 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote143 views1 answer
Load data from text file to mysql database on mac terminal
SQL