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 votes208 views1 answer
SQL find text in SP
SQL
0 vote198 views1 answer
SqlFunction does not exist
SQL
-1 vote194 views1 answer
Get id from just inserted row mysql server python
SQL
3 votes191 views2 answers
Oracle sql truncate table
SQL
0 vote202 views1 answer
Postgresql update to unique
SQL
1 vote207 views1 answer
Oracle nvl2
SQL
3 votes192 views1 answer
Postgresql db owner change
SQL
0 vote245 views1 answer
T-SQL Create Trigger
SQL
1 vote206 views1 answer
Mysql column start with string
SQL
0 vote215 views1 answer
Data directory postgresql
SQL