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 vote237 views1 answer
Float precision in psql
SQL
0 vote184 views1 answer
Mysql date minus 1 day
SQL
0 vote193 views1 answer
Psql get table data types
SQL
2 votes203 views2 answers
Postgresql get table names
SQL
1 vote293 views1 answer
Oracle datafile max size 32gb
SQL
4 votes202 views1 answer
Id increment ms sql server
SQL
51 votes294 views6 answers
Change column name sql
SQL
0 vote191 views1 answer
Calculate age in sql
SQL
1 vote195 views2 answers
Update with inner join sql server
SQL
1 vote391 views2 answers
Coderbyte sql solutions
SQL