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 vote309 views1 answer
Mysql remove last empty newline
SQL
0 vote366 views1 answer
What is metadata in sql
SQL
0 vote342 views1 answer
Neo4j command to run script file
SQL
0 vote303 views2 answers
How to start postgresql laravel
SQL
0 vote368 views1 answer
Wordpress make wp user in db
SQL
0 vote335 views1 answer
Oracle exchange subpartition
SQL
0 vote317 views2 answers
PostgreSQL having
SQL
1 vote335 views1 answer
Customer using hdfc bank sql query
SQL
20 votes310 views4 answers
Reset auto increment in MySQL
SQL
0 vote338 views1 answer
Psql get table data types
SQL