/SQL/Oracle transaction commit rollback example

Oracle transaction commit rollback 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

1 vote322 views1 answer
Mysql order by desc null last
SQL
11 votes331 views1 answer
Ddl materialized view
SQL
9 votes329 views4 answers
Add primary key to existing table sql
SQL
0 vote362 views1 answer
Sql contains numeric characters
SQL
0 vote361 views1 answer
Sql show table name in result
SQL
0 vote373 views1 answer
Check user sql password from command line
SQL
11 votes377 views1 answer
Ddl view
SQL
0 vote360 views1 answer
Java mysql swing example
SQL
0 vote309 views1 answer
Big query add table rows to another table
SQL
0 vote340 views1 answer
Change schema of all tables postgres
SQL