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

0 vote131 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote129 views1 answer
Oracle show running job
SQL
5 votes98 views1 answer
Pl sql asynchronous procedure calls
SQL
1 vote90 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
3 votes108 views3 answers
Stop mysql ubuntu
SQL
16 votes120 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote96 views1 answer
Sql check for null and empty string
SQL
0 vote132 views1 answer
Sqlalchemy orm duplicate
SQL
-1 vote105 views3 answers
How to restart mysql in linux
SQL
0 vote101 views1 answer
Sql declare variable single line
SQL