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 vote165 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote151 views1 answer
Dasebase_url-postgres for windows
SQL
0 vote129 views1 answer
Mysql collation for all languages
SQL
0 vote190 views1 answer
Like and not like together in sql
SQL
0 vote174 views3 answers
Query string not ending with with vowels
SQL
19 votes167 views6 answers
Laravel sql query
SQL
0 vote197 views1 answer
Mysql error codeigniter
SQL
0 vote187 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote167 views1 answer
Procedure excute monthly oracle
SQL
0 vote165 views1 answer
Show size of all tables postgres
SQL