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 vote350 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote327 views1 answer
Wordpress sql find and replace
SQL
0 vote337 views1 answer
Postgresql create user roles
SQL
0 vote378 views1 answer
Will graphql replace sql
SQL
0 vote355 views1 answer
How to define a save method in ruby for sql databases
SQL
1 vote384 views1 answer
Print all records of table in mysql
SQL
1 vote308 views1 answer
Strict in postgres SQL
SQL
0 vote343 views1 answer
Mysql auto increment default value with prefix month and year
SQL
2 votes395 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
1 vote347 views2 answers
Last working day in week date function in sql
SQL