/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 vote268 views1 answer
Psql human readable
SQL
5 votes243 views3 answers
Mysql check if null or empty string
SQL
5 votes253 views1 answer
How to check port number for postgresql
SQL
-1 vote267 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
4 votes269 views2 answers
Installing sql on ubuntu
SQL
0 vote247 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote252 views1 answer
St_buffer mysql
SQL
0 vote285 views1 answer
Sql date time query find
SQL
0 vote255 views2 answers
Mysql to python pandas
SQL
6 votes235 views1 answer
Oracle trigger after connect
SQL