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 vote307 views1 answer
How to get initials in sql
SQL
2 votes343 views1 answer
Q operator in oracle
SQL
0 vote378 views1 answer
Sql doesn't contain
SQL
0 vote335 views1 answer
Enable outgoing remote MySQL access
SQL
3 votes338 views1 answer
Query less than datetime sql
SQL
1 vote355 views1 answer
Floor function in sql oracle
SQL
-1 vote357 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote306 views1 answer
How to change mysql port in xampp
SQL
0 vote332 views1 answer
Sql last 3 rows
SQL
0 vote332 views1 answer
Typeorm raw sql
SQL