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

2 votes183 views1 answer
Q operator in sql
SQL
16 votes237 views3 answers
Order by sql query
SQL
0 vote171 views1 answer
Shrink database file in sql server
SQL
6 votes274 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
0 vote206 views1 answer
For row in sql database python loop
SQL
2 votes226 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
5 votes193 views1 answer
Oracle drop index if exists
SQL
-1 vote205 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote254 views1 answer
Restart serial number for postgres
SQL
12 votes225 views6 answers
How to install sqlite3 in python
SQL