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 vote363 views3 answers
Read all columns of a table sql
SQL
0 vote314 views1 answer
Change schema of all tables postgres
SQL
1 vote318 views2 answers
Mysql trim whitespace
SQL
2 votes362 views1 answer
Create mysql user on all hosts
SQL
0 vote333 views1 answer
Mysql multiple primary keys
SQL
7 votes338 views1 answer
Mysql iif
SQL
0 vote340 views2 answers
Homebrew nysql launch
SQL
7 votes311 views2 answers
N highest salary in sql
SQL
0 vote377 views1 answer
Mysql insert multiple rows based on select
SQL
20 votes310 views5 answers
Mysql reset auto increment to 1
SQL