/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 vote158 views1 answer
Check if has alpha characters sql
SQL
1 vote140 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
9 votes142 views2 answers
Default number in sql
SQL
7 votes147 views1 answer
Sql management studio display line numbers
SQL
20 votes153 views2 answers
Mysql bigint max value
SQL
1 vote165 views1 answer
Replace all numbers in mysql
SQL
-1 vote139 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote174 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote153 views1 answer
Mysql foreach insert
SQL
1 vote175 views1 answer
Sql and
SQL