/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 vote194 views1 answer
MySql Modify Increment
SQL
0 vote191 views1 answer
How get data from database if id not found then search another column
SQL
5 votes201 views5 answers
Sqlite install python
SQL
0 vote196 views1 answer
Sql create table with references not primary key
SQL
6 votes197 views1 answer
Identify primary key in oracle table
SQL
19 votes194 views5 answers
Mysql between date range
SQL
0 vote187 views1 answer
Find largest table in mysql database
SQL
0 vote149 views1 answer
Sql server is not
SQL
2 votes203 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote194 views2 answers
Database owner can't create new tables postgres
SQL