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 vote213 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote217 views1 answer
Raiserror with nowait
SQL
0 vote204 views2 answers
Csv into data postgres
SQL
0 vote217 views1 answer
Sql comand for removing data from table
SQL
7 votes206 views6 answers
Group_concat mysql
SQL
0 vote209 views1 answer
Function sum(text) does not exist postgres
SQL
2 votes204 views1 answer
Brew start postgres manual
SQL
6 votes241 views3 answers
Rename column ORACLE
SQL
0 vote204 views1 answer
Connexion mysql
SQL
0 vote214 views1 answer
Group by join columns per table
SQL