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

4 votes110 views3 answers
Oracle sql first day of quarter
SQL
1 vote109 views1 answer
Reutrn string after character sql
SQL
0 vote116 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote155 views3 answers
Mysql CAST(amount as float)
SQL
0 vote142 views1 answer
Primary key start from number
SQL
0 vote119 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote186 views4 answers
Stored procedure sql
SQL
1 vote111 views3 answers
Read all columns of a table sql
SQL
0 vote120 views1 answer
Declare or use variable in snowflake
SQL
0 vote125 views2 answers
How to generate a unique random number in mysql
SQL