/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 vote109 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote105 views1 answer
Sql server udf performance
SQL
0 vote109 views1 answer
Psql no such file or directory
SQL
0 vote104 views1 answer
Database xml sql
SQL
0 vote137 views1 answer
Store case result sql
SQL
0 vote100 views2 answers
Postgresql create role
SQL
0 vote100 views1 answer
Python mysql query where
SQL
7 votes109 views1 answer
Query delete duplicates
SQL
-1 vote116 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote105 views1 answer
Remove default constraint sql server
SQL