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 vote121 views3 answers
Average salary in sql
SQL
5 votes138 views2 answers
Oracle show procedures
SQL
0 vote143 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote138 views1 answer
Mysql check datetime equals date
SQL
0 vote138 views1 answer
Sql get highest date from 3 tabels
SQL
2 votes114 views2 answers
How to get capital letter first in sql
SQL
1 vote156 views1 answer
How to select random rows from a table
SQL
1 vote132 views1 answer
Select not matching data from two tables
SQL
0 vote129 views1 answer
Power bi dax add related shows column but not working
SQL
3 votes128 views3 answers
Create table in microsoft sql server
SQL