/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

5 votes203 views2 answers
Mysql dump mysql db cli
SQL
0 vote175 views1 answer
WHERE not regex in SQL
SQL
6 votes177 views2 answers
Mysql interval 1 day
SQL
0 vote179 views1 answer
Sql select random procentage from rows
SQL
0 vote124 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote182 views1 answer
What is top n result in sql
SQL
23 votes188 views4 answers
Uninstall postgresql ubuntu
SQL
2 votes219 views3 answers
Row number mssql
SQL
5 votes156 views1 answer
Sql select ciunt
SQL
1 vote190 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL