Oracle sql commit example

-- 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 vote189 views1 answer
Oracle query archive mode
SQL
5 votes220 views1 answer
AND OR NOT operators sql
SQL
0 vote208 views1 answer
Hibernate show sql xml property
SQL
5 votes196 views1 answer
Oracle nls session
SQL
0 vote199 views2 answers
MySQL top percent
SQL
1 vote215 views2 answers
Oracle leftmost characters
SQL
0 vote234 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote220 views1 answer
How to map sql column to custom names
SQL
1 vote212 views1 answer
Psql connect to another database
SQL
-1 vote196 views1 answer
Auto increment psql not primary key
SQL