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

1 vote326 views1 answer
Index a database column sql
SQL
5 votes349 views1 answer
Sqlite alter table add column
SQL
0 vote342 views2 answers
Auto increment column in mysql query results
SQL
10 votes361 views4 answers
Drop primary key
SQL
0 vote396 views1 answer
Postgres docs /copy metacomand
SQL
3 votes350 views2 answers
Mysql user permission database
SQL
4 votes349 views1 answer
Wildcard in sql
SQL
1 vote366 views1 answer
Wherein mysql
SQL
0 vote342 views1 answer
Equi joins in oracle
SQL
50 votes424 views6 answers
Install mysql on ubuntu
SQL