/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 vote288 views1 answer
Display total number of tables in mysql
SQL
0 vote323 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
1 vote325 views1 answer
Mysql connect bash
SQL
0 vote352 views1 answer
What is metadata in sql
SQL
1 vote295 views2 answers
Sql select only first occurrence
SQL
0 vote293 views2 answers
Null value in column violates not-null constraint
SQL
6 votes307 views1 answer
Oracle list primary key
SQL
2 votes314 views1 answer
Orcale index size
SQL
0 vote315 views1 answer
Sql cmd no truncate
SQL
1 vote322 views2 answers
Sql server find all foreign keys that reference a column
SQL