/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 vote104 views1 answer
Subquery aggregation
SQL
1 vote99 views1 answer
Sql auto date
SQL
0 vote97 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote105 views1 answer
Difference between min and max date sql
SQL
0 vote100 views1 answer
Difference between varchar and varchar2
SQL
10 votes115 views4 answers
Inner join in update query mysql
SQL
0 vote98 views1 answer
Install mysql for fedora 34
SQL
1 vote108 views1 answer
Mysql view curren querys
SQL
1 vote98 views1 answer
Mysql connect bash
SQL
0 vote100 views2 answers
Update all columns in one update
SQL