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

-1 vote289 views1 answer
How to dump .csv file into mysql
SQL
0 vote285 views1 answer
Sql get count without group by
SQL
1 vote276 views1 answer
Operator does not exist: integer = text
SQL
0 vote278 views1 answer
Character count sql
SQL
1 vote300 views1 answer
Postgresql substring last
SQL
0 vote307 views1 answer
Mysql url
SQL
2 votes306 views1 answer
Query to check cpu utilization in oracle database
SQL
1 vote328 views1 answer
Import sql file from laravel
SQL
7 votes257 views1 answer
Grant schema permissions postgres
SQL
0 vote277 views1 answer
Add computed column to table sql server
SQL