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 vote363 views1 answer
Database xml sql
SQL
0 vote422 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote398 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
1 vote376 views1 answer
Postgresql define pk sequence next number
SQL
0 vote348 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote370 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote434 views1 answer
Select * from mysql.proc
SQL
0 vote361 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote392 views4 answers
Open mysql port bitnami tomact
SQL
8 votes379 views2 answers
Oracle undo usage
SQL