/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 vote226 views1 answer
Oracle convert int to date
SQL
2 votes113 views3 answers
Application.properties spring boot mysql
SQL
1 vote112 views1 answer
Oracle create_program
SQL
0 vote97 views1 answer
Oracle activate program
SQL
0 vote101 views1 answer
How to get n result in sql
SQL
0 vote107 views1 answer
Sub query in linq
SQL
0 vote85 views1 answer
Possgress drop if exists view
SQL
0 vote114 views1 answer
Insert value in identity
SQL
2 votes115 views1 answer
Sql string_agg
SQL
5 votes170 views2 answers
Mysql date greater than 30 days
SQL