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

25 votes204 views6 answers
Modify column name in mysql
SQL
5 votes272 views3 answers
Create function in postgresql
SQL
7 votes228 views6 answers
Mysql group concat
SQL
1 vote158 views1 answer
Python escape string for sql
SQL
7 votes212 views2 answers
Sql server drop temp table if exists
SQL
-1 vote208 views2 answers
Mysql get day of week
SQL
1 vote198 views1 answer
Generate random data postgresql
SQL
0 vote221 views1 answer
Query builder doctrien return sql
SQL
22 votes211 views3 answers
Year format in date mysql
SQL
1 vote259 views1 answer
Mysql current running queries
SQL