/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 vote177 views1 answer
Kill thread
SQL
0 vote206 views1 answer
Hour and minute between two datatime sql
SQL
0 vote195 views1 answer
Fetching data from mysqldb
SQL
2 votes176 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
3 votes187 views1 answer
Postgresql today - 1 year
SQL
3 votes166 views1 answer
Sql select all
SQL
1 vote163 views2 answers
Mysql SELECT
SQL
1 vote189 views1 answer
Postgres left join
SQL
0 vote180 views2 answers
How to save result of sqlite query in a table
SQL
1 vote170 views1 answer
Get the User Name and Domain Name from an Email Address
SQL