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 votes202 views1 answer
Compare date in sql
SQL
1 vote192 views1 answer
How to install mysql 8.0 windows service
SQL
1 vote208 views1 answer
Update and replace mysql
SQL
0 vote217 views1 answer
Including parameters in OPENQUERY
SQL
0 vote182 views1 answer
Alter table fulltext
SQL
0 vote219 views1 answer
Mysql dump with table query
SQL
5 votes208 views1 answer
Sysdate in oracle sql
SQL
1 vote192 views1 answer
Not exists mysql
SQL
2 votes224 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote190 views1 answer
Oracle index hint multiple tables example
SQL