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 vote132 views1 answer
Dnsmasq.conf location macos
SQL
0 vote161 views1 answer
How to set up an anonymous function to variable in swift
SQL
1 vote177 views1 answer
Base64 encode sql server
SQL
1 vote178 views1 answer
Postgres select as csv
SQL
0 vote139 views1 answer
Oracle list subpartitions
SQL
1 vote142 views1 answer
How to find median of a column sql
SQL
1 vote142 views1 answer
How to see logical reads in sql server
SQL
3 votes144 views2 answers
Postgres inner join vs join
SQL
10 votes135 views3 answers
Sql limit results
SQL
0 vote144 views1 answer
Coalesce for comma separated in sql server
SQL