Oracle sql commit 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 vote139 views2 answers
Python mysql create table if not exists
SQL
0 vote141 views1 answer
SQL server datetime compare
SQL
1 vote152 views2 answers
One to one and one to many relationship
SQL
0 vote135 views1 answer
Sql column as header
SQL
0 vote129 views1 answer
Transaction database with php
SQL
3 votes131 views3 answers
Into in sql
SQL
-1 vote90 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote133 views1 answer
Google sheets filter rows above current cell
SQL
0 vote124 views1 answer
Create table employees oracle
SQL
1 vote119 views1 answer
How to delete data from sql database in android
SQL