Oracle rollback

-- 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 vote186 views1 answer
Sql server whoami
SQL
0 vote211 views1 answer
Sql: extract day text from datetime value
SQL
0 vote204 views1 answer
SQL Server date literal
SQL
1 vote173 views1 answer
Sql myisam vs innodb
SQL
1 vote159 views1 answer
Mysql collation
SQL
1 vote198 views1 answer
How to update date add hours in postgresql
SQL
1 vote199 views1 answer
Load mysql dumb
SQL
0 vote183 views1 answer
Recursive query herarchical data sql server
SQL
0 vote191 views1 answer
Find invalid datetime field
SQL
1 vote211 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL