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

6 votes331 views2 answers
Oracle undotbs usage
SQL
0 vote258 views1 answer
Replace sqlalchemy
SQL
-1 vote278 views2 answers
Postgresql get last 10 records
SQL
0 vote256 views1 answer
Mysql error codeigniter
SQL
7 votes273 views6 answers
Nth highest salary in sql
SQL
0 vote271 views1 answer
Sql add calculated column
SQL
2 votes277 views1 answer
Sql as
SQL
0 vote253 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote267 views1 answer
Convert rows into columns in oracle
SQL
0 vote278 views1 answer
Sql server select value large text
SQL