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 vote281 views1 answer
Mysql_error replacement
SQL
3 votes298 views1 answer
Oracle sleep
SQL
1 vote306 views2 answers
Foreign key set 0
SQL
3 votes287 views2 answers
To_char oracle
SQL
0 vote280 views1 answer
Sql row number in result set
SQL
0 vote292 views1 answer
User defined variables in sql
SQL
2 votes269 views1 answer
Mysql select random id from table
SQL
0 vote300 views1 answer
Change filed order in mysql
SQL
1 vote268 views1 answer
Sql week commencing date
SQL
0 vote281 views1 answer
Oracle db get table sizes
SQL