/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

2 votes346 views1 answer
Can you use a where clause for a child query
SQL
0 vote370 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote325 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote307 views1 answer
Pl sql turn off variable substitution
SQL
3 votes332 views1 answer
Force using index oracle
SQL
0 vote457 views1 answer
Postgresql powershell query
SQL
5 votes318 views1 answer
Ascending order and where in sql
SQL
0 vote327 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote337 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote360 views2 answers
Get item by composite primary key mysql
SQL