/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

7 votes207 views2 answers
Mysql check db size
SQL
22 votes216 views4 answers
Mysql date_format
SQL
5 votes306 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
5 votes287 views1 answer
Mysql last day of next month
SQL
11 votes189 views4 answers
MYSQL LOGIN
SQL
0 vote208 views1 answer
Nvl2 syntax
SQL
8 votes226 views1 answer
Declare table variable sql server
SQL
0 vote206 views1 answer
Create user faunadb
SQL
3 votes221 views1 answer
Where id is in list sql
SQL
0 vote250 views1 answer
How to fetch data from database in sql
SQL