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

4 votes352 views2 answers
Convert utc to est sql
SQL
1 vote333 views1 answer
How to print longest name in sql
SQL
2 votes410 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote373 views1 answer
Mysql equivalent decode oracle
SQL
32 votes370 views6 answers
How to change column name in sql
SQL
0 vote360 views1 answer
T-SQL Create Trigger
SQL
0 vote415 views1 answer
Generate a random otp in sql server
SQL
0 vote421 views1 answer
Sql query inline if
SQL
2 votes371 views3 answers
Postgres create view
SQL
0 vote349 views1 answer
No suitable driver found for sqlite
SQL