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 vote9.7K views1 answer
Postgresql delete type
SQL
0 vote182 views1 answer
Acual month sql
SQL
1 vote200 views1 answer
Write a query to create an empty table from an existing table?
SQL
1 vote188 views1 answer
Oracle create as select
SQL
0 vote174 views1 answer
Alter boolean column postgresql
SQL
1 vote183 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote224 views1 answer
Sql remove decimal places
SQL
0 vote202 views1 answer
Microsoft word insert sql code
SQL
0 vote198 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
9 votes206 views1 answer
Alter table column change data type to text mysql
SQL