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 votes252 views3 answers
Row number mssql
SQL
0 vote329 views2 answers
Mysql insert rows to another database
SQL
1 vote261 views1 answer
Psql autocomplete for mac brew install
SQL
1 vote275 views1 answer
Update foreign key value in mysql
SQL
1 vote268 views1 answer
How to see logical reads in sql server
SQL
0 vote274 views1 answer
How to delete python anywhere mysql database
SQL
0 vote262 views1 answer
Executescalar in sql server
SQL
11 votes282 views1 answer
Ddl view
SQL
13 votes269 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote270 views1 answer
Postgres sequence name
SQL