/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 vote156 views1 answer
Psql connections
SQL
1 vote161 views1 answer
Return size of tables in mysql
SQL
1 vote204 views2 answers
Login to mysql
SQL
0 vote166 views1 answer
Postgresql auto increment not working
SQL
1 vote159 views1 answer
Mamp mysql path mac
SQL
13 votes315 views4 answers
Sql joining 3 tables
SQL
2 votes158 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote143 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote156 views1 answer
Postgresql create table with boolean column
SQL
11 votes146 views2 answers
Having clause
SQL