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 vote234 views1 answer
Install squirrel sql ubuntu
SQL
1 vote222 views1 answer
Set all the vluses in calumn in sql to false
SQL
1 vote226 views2 answers
Postgres copy table from one schema to another
SQL
1 vote219 views1 answer
Mysql random limit 1
SQL
0 vote224 views1 answer
H2 auto increment and unique
SQL
4 votes211 views1 answer
Wilayah indonesia database
SQL
1 vote238 views1 answer
Sql dcl
SQL
1 vote231 views1 answer
How to use a trigger to validate input data
SQL
0 vote314 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote230 views1 answer
Sql server port 1434
SQL