/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

0 vote263 views1 answer
Look at running processes redshift
SQL
1 vote216 views1 answer
Select not matching data from two tables
SQL
1 vote281 views1 answer
Hangfire clear all jobs
SQL
0 vote222 views1 answer
Mysql export data with a where clause
SQL
0 vote220 views1 answer
Composit key in sql
SQL
6 votes221 views1 answer
Update left join mysql
SQL
1 vote225 views4 answers
Psql check tables command
SQL
1 vote225 views1 answer
Add current timestamp in mysql
SQL
0 vote221 views1 answer
How to check which sp is running in sql server
SQL
-1 vote220 views1 answer
How to check table exists or not in postgresql
SQL