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

4 votes102 views1 answer
Id primary key auto generated
SQL
8 votes109 views2 answers
Update sql server from another table
SQL
0 vote109 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote121 views1 answer
Mysql order by where condition sub query
SQL
2 votes121 views2 answers
Change mysql password from command line
SQL
0 vote101 views1 answer
T-sql email validation
SQL
0 vote101 views1 answer
Mysql repair a table
SQL
1 vote113 views1 answer
Raw query must include primary key
SQL
3 votes181 views2 answers
Savepoint in sql
SQL
0 vote95 views1 answer
Sql trim whitespace
SQL