/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

3 votes132 views2 answers
Sqlite print all column names
SQL
2 votes176 views3 answers
Mysql cheat sheet
SQL
0 vote117 views1 answer
Group by 15 minute interval sql server
SQL
12 votes141 views6 answers
Between in sql
SQL
0 vote141 views3 answers
Sql query checker
SQL
12 votes185 views2 answers
Update column data type postgres
SQL
0 vote138 views1 answer
Oracle concat datetime
SQL
1 vote253 views2 answers
Postgres select from last 3 months
SQL
0 vote144 views1 answer
.sql File Run in PSQL
SQL
1 vote125 views1 answer
Spring postgresql reset auto increment to 0
SQL