/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 vote208 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote193 views1 answer
Inserted row count tsql
SQL
0 vote228 views1 answer
Stratified sampling sql
SQL
1 vote326 views1 answer
Oracle current sequence value
SQL
0 vote209 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote224 views1 answer
Data types mysql vs postgresql
SQL
0 vote193 views1 answer
Suse start MySQL
SQL
0 vote193 views1 answer
How many columns can be used for creating index?
SQL
5 votes200 views2 answers
Oracle tables with column name
SQL
0 vote183 views1 answer
Check if table exists oracle
SQL