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 vote287 views2 answers
Mysql update two tables at once
SQL
3 votes269 views1 answer
Fk in insert mysql
SQL
2 votes257 views1 answer
Possgress drop if exists table
SQL
22 votes280 views3 answers
Remove all records from table mysql
SQL
0 vote295 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote258 views1 answer
Reading from right to left from string find first special characters in sql
SQL
2 votes276 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
1 vote234 views2 answers
Delete auto increment mysql
SQL
0 vote287 views1 answer
Postgres dump sql insert
SQL
4 votes256 views2 answers
Select first and last row mysql
SQL