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 vote339 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote305 views2 answers
Select limit ms sql
SQL
1 vote310 views2 answers
Mysql does sentance contain word
SQL
0 vote336 views3 answers
Postgresql allow remote connections
SQL
0 vote314 views1 answer
Like and not like together in sql
SQL
0 vote312 views1 answer
If null don't update
SQL
13 votes350 views1 answer
Views in sql
SQL
1 vote301 views1 answer
Update from select join
SQL
1 vote375 views1 answer
Mariadb get column names from table
SQL
1 vote356 views1 answer
Update foreign key value in mysql
SQL