Oracle rollback

-- 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 vote278 views1 answer
Tsql cmd exec script from file
SQL
0 vote287 views1 answer
Mysql query to add hours to column in table
SQL
0 vote320 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote323 views1 answer
Mysql workbench format date
SQL
0 vote264 views1 answer
Sql comparison operators
SQL
14 votes301 views2 answers
Oracle add column with default value
SQL
0 vote276 views2 answers
Sql update top 100
SQL
0 vote319 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
1 vote270 views1 answer
Sql only five first row
SQL
5 votes326 views4 answers
SQL Order of execution
SQL