/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

3 votes175 views3 answers
Mysql auto increment after delete
SQL
0 vote148 views1 answer
Find most frequent value in SQL column
SQL
0 vote147 views1 answer
Oracle procedure chain step
SQL
2 votes106 views1 answer
Sql float to int
SQL
0 vote143 views1 answer
Sql server split string and insert into table select
SQL
0 vote144 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote143 views1 answer
Sql count null as 0
SQL
11 votes140 views1 answer
Oracle view ddl
SQL
1 vote145 views1 answer
Oracle rolling back transactions
SQL
4 votes176 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL