Oracle sql commit 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 vote143 views1 answer
Replace \n sql
SQL
24 votes154 views4 answers
Mysql datetime
SQL
9 votes127 views2 answers
Get first 3 letters in sql
SQL
-1 vote170 views1 answer
Sql show custom constraints
SQL
0 vote136 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
4 votes138 views4 answers
Sqlite describe table
SQL
0 vote135 views1 answer
Oracle dynamic select into
SQL
0 vote225 views1 answer
Database timezone
SQL
0 vote180 views1 answer
Sql check if field is not null
SQL
-2 votes135 views1 answer
Use of where in left join in mysql
SQL