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

2 votes326 views1 answer
Sql ends with string
SQL
1 vote276 views1 answer
Mysql see column types
SQL
1 vote352 views1 answer
Connect to mysql database ubuntu
SQL
19 votes335 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote332 views1 answer
Mysql select smaller of two values
SQL
0 vote338 views1 answer
Search mysql database for column
SQL
0 vote337 views1 answer
Oracle table free space
SQL
1 vote329 views1 answer
Mysql backup skip table
SQL
1 vote327 views2 answers
Mysql between
SQL
1 vote341 views1 answer
Mysql drop key
SQL