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

23 votes144 views6 answers
Delete all rows from table sql
SQL
15 votes154 views2 answers
Open postgress in terminal mac
SQL
0 vote177 views1 answer
Sort by
SQL
0 vote161 views2 answers
Timing sql queries
SQL
0 vote160 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote420 views1 answer
Create pl/sql stored procedure
SQL
24 votes153 views5 answers
Sql server insert into select
SQL
3 votes146 views2 answers
Laravel tosql with bindings
SQL
0 vote172 views1 answer
Repeatable read trong sql server
SQL
0 vote152 views1 answer
How to write if case in select query in select statement
SQL