/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 vote193 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
12 votes205 views6 answers
Change mysql root password
SQL
0 vote224 views1 answer
000webhost database values insert
SQL
7 votes182 views3 answers
Sql update where id
SQL
2 votes184 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
3 votes194 views1 answer
Increment integer in table sql
SQL
0 vote226 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote193 views1 answer
Sql server separar numeros por comas miles
SQL
50 votes281 views6 answers
Install mysql on ubuntu
SQL
0 vote206 views1 answer
Sql select sum group by id laravel join
SQL