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 vote277 views1 answer
Xampp increame mysql speed
SQL
12 votes306 views1 answer
Run mysql instance in docker
SQL
10 votes309 views4 answers
Mysql if else
SQL
5 votes308 views1 answer
Oracle drop index if exists
SQL
1 vote270 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
7 votes292 views5 answers
Sql remove spaces
SQL
0 vote267 views1 answer
Postgresql regular expression special characters
SQL
28 votes278 views4 answers
Show tables mysql
SQL
0 vote269 views1 answer
Sql offfset
SQL
0 vote260 views1 answer
Time in sql server
SQL