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 vote150 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote229 views3 answers
Constraint sql
SQL
0 vote190 views1 answer
Get a list of tables and the primary key
SQL
0 vote150 views1 answer
Postgres delete where id in
SQL
0 vote171 views1 answer
Mysql database is not starting in xampp
SQL
0 vote173 views1 answer
Oracle list index on table
SQL
0 vote244 views1 answer
Ora 00001 error catch plsql
SQL
-1 vote194 views1 answer
Utf8_encode mysql
SQL
0 vote208 views2 answers
Identity syntax in sql
SQL
0 vote248 views1 answer
Best sql collation
SQL