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 vote215 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
10 votes193 views2 answers
Sql pagination offset
SQL
0 vote205 views1 answer
Gcloud sql list databases
SQL
0 vote195 views1 answer
How to delete python anywhere mysql database
SQL
0 vote182 views2 answers
Imageview setimageresource null
SQL
1 vote193 views1 answer
Top 10 rows in mysql
SQL
0 vote207 views1 answer
Calculer pourcentage mysql
SQL
0 vote179 views1 answer
Create database store
SQL
1 vote172 views2 answers
Postgres copy table from one schema to another
SQL
0 vote199 views1 answer
Sqlite explain plan
SQL