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 vote182 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote105 views1 answer
How to set field to null in sql
SQL
0 vote141 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
5 votes161 views2 answers
Create function postgresql
SQL
0 vote203 views1 answer
How to compile a function in oracle
SQL
0 vote148 views1 answer
How to use query in nosql
SQL
17 votes145 views4 answers
Sort by mysql
SQL
0 vote141 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote207 views2 answers
Cascade syntax in sql
SQL
1 vote165 views1 answer
Oracle insert multiple rows into same table
SQL