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

13 votes140 views2 answers
Get tables in database sql
SQL
0 vote139 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote132 views1 answer
Mysql record group by created date count
SQL
0 vote145 views1 answer
Sql tablo hangi sp de
SQL
0 vote175 views1 answer
Update sql sintax
SQL
0 vote150 views1 answer
Sql query use select name inside where clause
SQL
2 votes135 views2 answers
Get all tables using like
SQL
3 votes216 views1 answer
Sql add two values together
SQL
0 vote142 views1 answer
Sql select most frequent value in column
SQL
0 vote142 views1 answer
Oracle NLS_CHARACTERSET
SQL