/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 vote168 views1 answer
Oracle temporary table
SQL
33 votes108 views2 answers
Postgres how to add field created at
SQL
5 votes133 views2 answers
Postgresql insert select
SQL
1 vote106 views1 answer
Postgres grant read only access to database
SQL
0 vote142 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
1 vote119 views1 answer
Sample in sql
SQL
0 vote115 views1 answer
Contact mysql column field
SQL
0 vote112 views3 answers
Postgres trim string
SQL
0 vote124 views1 answer
How to print some string in mysql
SQL
0 vote139 views1 answer
Sql tablo sp
SQL