/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

11 votes344 views2 answers
MySQL DISTINCT
SQL
0 vote397 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote364 views1 answer
Get rows from 1 table with other table empty mysql
SQL
2 votes367 views1 answer
Update with join sql server
SQL
0 vote364 views1 answer
VSCode SQL Server Connection error
SQL
1 vote342 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote342 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote384 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
1 vote409 views1 answer
UseSqlServer no definition
SQL
1 vote375 views1 answer
Raise application error in oracle
SQL