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 vote129 views1 answer
Flask-sqlalchemy filter_by contains
SQL
6 votes174 views1 answer
Update left join mysql
SQL
2 votes165 views1 answer
Scaffold npgsql net core
SQL
2 votes206 views1 answer
Search query in mysql
SQL
0 vote200 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote184 views1 answer
Add SuperUser MySQL
SQL
0 vote196 views1 answer
How to get button for every record from mysql
SQL
0 vote203 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote215 views1 answer
Get max salary from each department sql
SQL
0 vote188 views1 answer
How to close external sql connection in laravel
SQL