/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

12 votes117 views4 answers
Mysql get date difference in hours
SQL
6 votes137 views2 answers
Difference between join vs union
SQL
0 vote80 views1 answer
Delete all rows from table sqlite
SQL
3 votes136 views2 answers
Search text in all sql server stored procedure
SQL
2 votes135 views1 answer
Import large .sql files into lampp
SQL
15 votes110 views4 answers
T-sql drop function if exists
SQL
0 vote134 views1 answer
Mysql check datetime equals date
SQL
1 vote155 views1 answer
Mysql current running queries
SQL
0 vote146 views1 answer
Ubuntu connect to mssql database
SQL
10 votes93 views2 answers
Sql where clause multiple values
SQL