Oracle sql commit example

-- 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 vote283 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 vote381 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote288 views1 answer
Oracle character index
SQL
0 vote309 views1 answer
How to define a non primary composite key in sql
SQL
1 vote297 views2 answers
Postgres copy table from one schema to another
SQL
0 vote327 views1 answer
Oracle sql developer closed connection
SQL
3 votes281 views1 answer
Oracle limit user tablespace
SQL
2 votes308 views1 answer
Oracle list duplicates
SQL
0 vote283 views1 answer
How much table store postgres
SQL
2 votes270 views2 answers
Insert all in sql
SQL