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 vote138 views1 answer
Mysql where sum > 0
SQL
0 vote115 views1 answer
Convert polygon to text in mysql
SQL
9 votes116 views1 answer
Oracle get table schema
SQL
0 vote161 views1 answer
MySQL update with subquery
SQL
0 vote105 views1 answer
Mysql database hyphen
SQL
0 vote98 views4 answers
Mysql count table rows
SQL
0 vote117 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote102 views1 answer
SQL SELECT-Klausel
SQL
0 vote198 views1 answer
Install ms sql server management studio
SQL
0 vote97 views1 answer
QCompleter con sql
SQL