/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 vote313 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote309 views1 answer
Mariadb set vertical output format
SQL
1 vote344 views1 answer
Sql select sum group by id laravel
SQL
5 votes275 views1 answer
Oracle ora-00054 causes
SQL
0 vote298 views1 answer
Transaction database with php
SQL
0 vote278 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote327 views1 answer
Stored procedure function relation
SQL
0 vote300 views1 answer
Stored function in sql
SQL
0 vote358 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
3 votes326 views1 answer
Oracle sql commit example
SQL