/SQL/Oracle transaction commit rollback example

Oracle transaction commit rollback 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

2 votes383 views1 answer
Postgresql group by month and year
SQL
10 votes359 views2 answers
Mysql drop database if exists
SQL
0 vote319 views1 answer
Sql query for getting data with join and count
SQL
11 votes342 views1 answer
Oracle view ddl
SQL
15 votes363 views4 answers
Sql update from select
SQL
0 vote323 views1 answer
Mysql into outfile with headers
SQL
0 vote349 views3 answers
Classement rang mysql 7
SQL
0 vote432 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote342 views2 answers
Sql server Insert Into table
SQL
-2 votes359 views1 answer
How-to-remove-mysql-root-password
SQL