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 vote209 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote239 views1 answer
Mysql url
SQL
0 vote221 views1 answer
Mysql c commands
SQL
0 vote213 views1 answer
Mysql add to value
SQL
4 votes212 views1 answer
Adding data to table in sql python
SQL
0 vote231 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote227 views1 answer
Sql server set complex constraints
SQL
1 vote235 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote231 views1 answer
Excel vba import data to sql server
SQL
1 vote172 views1 answer
Postgres division by zero
SQL