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 vote116 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
2 votes102 views1 answer
Mysql auto increment jumping
SQL
1 vote361 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote110 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote83 views1 answer
Raven ql select count
SQL
3 votes127 views2 answers
How to delete git repo locally
SQL
1 vote124 views2 answers
Oracle list partitioned tables
SQL
12 votes115 views3 answers
Duplicate a column in sql
SQL
2 votes131 views1 answer
Sql percentage with % rounded down
SQL
0 vote76 views1 answer
Postgresql subquery
SQL