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

2 votes110 views1 answer
Oracle sql concatenate results into string
SQL
1 vote116 views1 answer
Mysql data from file
SQL
15 votes117 views2 answers
How to know the username of postgresql
SQL
0 vote149 views1 answer
Sql int vs integer
SQL
2 votes113 views2 answers
How to get capital letter first in sql
SQL
1 vote111 views2 answers
Postgres copy table from one schema to another
SQL
0 vote121 views1 answer
Guid string to binary better
SQL
0 vote119 views8 answers
Convert sql query to linq online
SQL
0 vote120 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote113 views1 answer
Incorrect datetime value sql table error 1292
SQL