/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

2 votes197 views3 answers
Sql server: how to concatenate column data using comma
SQL
1 vote138 views1 answer
Metada in sql
SQL
2 votes210 views1 answer
Python sql
SQL
25 votes172 views3 answers
Mysql command show tables
SQL
1 vote156 views1 answer
Psql show with user is logged in
SQL
3 votes167 views1 answer
Kill mysql processlist in whose time more than 200
SQL
6 votes173 views4 answers
Mysql group by month
SQL
0 vote156 views1 answer
Mod function example
SQL
0 vote160 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote186 views1 answer
Default password for mysql_secure_installation in mac
SQL