/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

8 votes201 views3 answers
Mysql alter table add index
SQL
27 votes217 views6 answers
Set password mysql
SQL
0 vote220 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
1 vote226 views1 answer
Altrer name column postgres
SQL
1 vote200 views1 answer
Show indices in mysql table
SQL
25 votes223 views4 answers
Sqlserver add column
SQL
12 votes219 views4 answers
Mysql ifnull
SQL
0 vote208 views1 answer
Concatenate columns in table
SQL
0 vote204 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote226 views1 answer
Mysql last 6 months
SQL