/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 vote167 views1 answer
Show table columns
SQL
1 vote163 views1 answer
Data type and their numeric form
SQL
8 votes174 views1 answer
Oracle create datafile
SQL
1 vote222 views1 answer
Sample clause in sql
SQL
0 vote178 views1 answer
Get record which is available in one table but not in another mysql
SQL
23 votes181 views5 answers
Sql substring
SQL
1 vote165 views1 answer
What is int in mysql
SQL
0 vote178 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
8 votes174 views2 answers
Replace string value in sql
SQL
0 vote162 views1 answer
Sql server bool select
SQL