/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 vote351 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote349 views1 answer
Contact mysql column field
SQL
-1 vote313 views1 answer
Oracle db list usernames
SQL
0 vote360 views1 answer
Helptext in sql
SQL
1 vote333 views1 answer
Varchar plsql
SQL
0 vote351 views1 answer
Sql create table with datetime automatically
SQL
1 vote376 views1 answer
Oracle compile schema
SQL
1 vote339 views2 answers
End mysql command
SQL
0 vote356 views1 answer
Linebreak sql
SQL
0 vote343 views1 answer
Sql query to check if column contains alphabets
SQL