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 vote147 views1 answer
View t-sql mail configuration
SQL
1 vote113 views1 answer
Mysql show attributes of a table
SQL
0 vote187 views1 answer
Sql from null to not null
SQL
1 vote2.3K views1 answer
Dropping a constraint in ms sql
SQL
1 vote166 views1 answer
Postgres get month name from date
SQL
0 vote160 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote212 views1 answer
Postgres select from values
SQL
0 vote154 views1 answer
FIND most frequent word in sql server
SQL
3 votes147 views1 answer
Select without null values sql
SQL
0 vote158 views1 answer
Postgres list tables and row counts
SQL