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 vote121 views1 answer
Mysql convert charset
SQL
0 vote134 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote148 views1 answer
Find how many tables in database sql query
SQL
12 votes190 views4 answers
How to drop all tables in postgresql
SQL
11 votes121 views4 answers
Query DISTINCT
SQL
1 vote139 views1 answer
Psql connect to another database
SQL
0 vote198 views4 answers
Stored procedure sql
SQL
1 vote130 views1 answer
Return size of tables in mysql
SQL
0 vote163 views3 answers
Characters found after end of sql statement
SQL
5 votes119 views1 answer
Mysql select greater than yesterday
SQL