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

-1 vote202 views2 answers
Import data from excel to sql server automatically
SQL
0 vote193 views1 answer
Sql show all users
SQL
0 vote252 views1 answer
Two inner joins sql
SQL
8 votes204 views1 answer
Oracle search text in all packages
SQL
16 votes197 views4 answers
Mysql import from sql file
SQL
0 vote201 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
9 votes207 views4 answers
Mysql set id auto increment
SQL
23 votes200 views3 answers
Sql where contains part of string
SQL
0 vote195 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
4 votes202 views1 answer
T-sql get duplicate rows
SQL