/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

12 votes276 views2 answers
Delete all nodes neo4j
SQL
1 vote273 views1 answer
Show per page table in xampp
SQL
0 vote276 views2 answers
Oracle create chain rule
SQL
0 vote280 views1 answer
Search column name sql
SQL
0 vote272 views1 answer
Mysql select where field is a value
SQL
3 votes266 views3 answers
Mysql get table size
SQL
0 vote282 views1 answer
C# add a textbox in mysql select
SQL
0 vote245 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote277 views1 answer
Mysql set column equal to another automatic
SQL
27 votes277 views4 answers
Get all tables with column name sql
SQL