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 vote188 views1 answer
Change magento database url usimg musql
SQL
0 vote253 views1 answer
How to connect to xampp sql server on windows cmd
SQL
4 votes177 views2 answers
Truncate oracle
SQL
5 votes200 views1 answer
Oracle drop index if exists
SQL
3 votes283 views3 answers
Mysql get table size
SQL
0 vote187 views2 answers
Connect to mysql server mac terminal
SQL
0 vote195 views1 answer
Mysql zerofill
SQL
19 votes225 views5 answers
Display table in sql
SQL
10 votes174 views2 answers
Linux command line import mysql database
SQL
0 vote227 views1 answer
Mysql 3 months ago
SQL