/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 vote255 views1 answer
Allow null in psql
SQL
0 vote245 views1 answer
Create a sql server database programmatically
SQL
2 votes288 views1 answer
Remove foreign key constraints in postgres
SQL
0 vote285 views1 answer
Mysql concatenate select results
SQL
11 votes244 views2 answers
Oracle source code
SQL
0 vote238 views1 answer
Foreign key multiple columns
SQL
2 votes246 views2 answers
Mysql on duplicate key update get value from values
SQL
2 votes189 views1 answer
Sql view column data type
SQL
0 vote228 views1 answer
Assign value to var in SQL
SQL
0 vote262 views2 answers
How to truncate all table in mysql workbench
SQL