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 vote735 views1 answer
Sql show table name in result
SQL
0 vote205 views1 answer
Sql_inner_join
SQL
0 vote281 views3 answers
Fetlife
SQL
0 vote188 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote249 views1 answer
Php insert null mysql
SQL
1 vote178 views2 answers
Mysql show views
SQL
1 vote173 views1 answer
Sql delete row with auto increment
SQL
1 vote183 views1 answer
Mysql select utc time in eastern time
SQL
0 vote185 views1 answer
What is between keyword used for
SQL
4 votes205 views3 answers
Rename table column postgresql
SQL