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 vote265 views1 answer
SQL: calculate hours from two dates
SQL
10 votes211 views2 answers
Django mysql
SQL
0 vote254 views1 answer
SQL Server Altering Column to be Unique
SQL
7 votes291 views3 answers
Sql update where id
SQL
1 vote264 views2 answers
Begin transaction in sql
SQL
0 vote253 views1 answer
Oracle synonym procedure dblink
SQL
0 vote263 views1 answer
Mysql grouping functions
SQL
0 vote321 views1 answer
Oracle calculate statistics on partition
SQL
0 vote287 views1 answer
Bitmap join index
SQL
4 votes266 views1 answer
Group by mysql and concatenate string
SQL