/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

0 vote172 views2 answers
Mysql disable foreign key checks
SQL
1 vote184 views2 answers
Mysql update LAST_INSERT_ID()
SQL
2 votes240 views2 answers
Postgres set user as superuser
SQL
1 vote314 views1 answer
Postgres set column based on another column
SQL
2 votes180 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote202 views1 answer
Sql show founctions
SQL
0 vote173 views1 answer
Install mysql for fedora 34
SQL
0 vote174 views1 answer
Create table if not exist with exceptions
SQL
2 votes197 views3 answers
Row number mysql
SQL
1 vote181 views1 answer
Too many connections mysql
SQL