/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

1 vote163 views2 answers
Mysql does sentance contain word
SQL
0 vote103 views1 answer
Import csv to mysql
SQL
1 vote172 views2 answers
Install sql server management studio ubuntu
SQL
0 vote132 views1 answer
How to connect postgresql database with java
SQL
20 votes150 views3 answers
How to open postgresql in mac
SQL
2 votes133 views1 answer
Install sqlite npm
SQL
0 vote129 views1 answer
Truncate table sql server foreign key
SQL
3 votes139 views2 answers
Mysql create timestamp column
SQL
0 vote136 views1 answer
Parsing float to int in mysql
SQL
6 votes158 views2 answers
Postgresql pg_dump
SQL