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

1 vote300 views1 answer
Oracle split string
SQL
0 vote313 views1 answer
Compare two tables to find unmatched records
SQL
0 vote309 views1 answer
Insert output identity
SQL
8 votes319 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
-1 vote314 views2 answers
Postgresql user permissions to database
SQL
7 votes329 views2 answers
Phpmyadmin change password
SQL
0 vote289 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote310 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote302 views1 answer
SQL add a totals of differemt rows of the same id
SQL
1 vote355 views1 answer
Oracle drop temporary table
SQL