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

9 votes155 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote160 views1 answer
Oracle last connexion
SQL
0 vote145 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
3 votes148 views1 answer
Create a table with an id in mysql
SQL
24 votes151 views4 answers
Postgres delete database
SQL
0 vote179 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote157 views1 answer
Is not sql
SQL
2 votes227 views1 answer
Mysql create user with remote access
SQL
9 votes158 views2 answers
SELECT User,Host FROM mysql.user;
SQL
1 vote155 views1 answer
Sample in sql
SQL