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

4 votes120 views2 answers
Mysql select where starts with
SQL
1 vote131 views2 answers
Begin transaction in sql
SQL
0 vote122 views1 answer
Date 3 months from today sql
SQL
0 vote136 views1 answer
Sqlserver now
SQL
0 vote121 views2 answers
Sql day from datetime
SQL
0 vote122 views1 answer
Select from another database
SQL
5 votes203 views1 answer
Oracle asynchronous procedure
SQL
3 votes136 views1 answer
Select database in sql
SQL
0 vote149 views1 answer
Mysql dump with table query
SQL
1 vote141 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL