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 vote204 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote201 views1 answer
Xampp increame mysql speed
SQL
0 vote203 views1 answer
How to save data in database in mysql node
SQL
0 vote196 views1 answer
Flask sqlalchemy update row
SQL
0 vote215 views1 answer
Import Data in MySQL without using any other software
SQL
-1 vote204 views1 answer
Sql syntax create timestamp column
SQL
1 vote233 views3 answers
Sql procedure
SQL
0 vote235 views1 answer
Oracle list dblink
SQL
2 votes164 views4 answers
Mysql change database character set to utf8mb4
SQL
1 vote281 views1 answer
Connect to mysql database ubuntu
SQL