/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 vote196 views1 answer
How to show current database in mysql
SQL
0 vote144 views1 answer
Alter check command
SQL
21 votes134 views6 answers
Docker run mysql
SQL
0 vote140 views1 answer
New rails app with mysql
SQL
0 vote145 views1 answer
How we can perform acid Operations in sql with examples
SQL
7 votes121 views1 answer
Forge server hosting
SQL
0 vote131 views1 answer
Add multiple field in table sql
SQL
1 vote81 views1 answer
Postgresql last element of array
SQL
-1 vote124 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote141 views1 answer
Mysqldump don't drop table
SQL