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

13 votes125 views2 answers
Check if value is null mysql
SQL
0 vote128 views1 answer
Create table if not exist with exceptions
SQL
16 votes131 views3 answers
Delete row psql
SQL
1 vote143 views1 answer
Create sqlite database in laravel
SQL
0 vote163 views1 answer
Mysql get hour from datetime
SQL
6 votes131 views2 answers
Mysql get yesterday
SQL
0 vote138 views1 answer
Download sql file of countries names
SQL
3 votes183 views1 answer
Oracle function
SQL
13 votes90 views2 answers
Oracle all source
SQL
8 votes127 views1 answer
Today minus 15 days postgresql
SQL