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 vote175 views1 answer
Cannot pip install mysqlclient
SQL
0 vote177 views1 answer
Oracle list partitions
SQL
0 vote173 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote161 views1 answer
Execut sql python
SQL
50 votes278 views6 answers
Sql count duplicate rows
SQL
4 votes182 views1 answer
Sql quote in string
SQL
0 vote296 views2 answers
Mysql insert rows to another database
SQL
2 votes228 views2 answers
Create table mysql integer NOT null
SQL
1 vote186 views1 answer
Mysql select for update ejemplo
SQL
5 votes218 views1 answer
How to get all table names in sql query
SQL