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 vote128 views1 answer
Pgadmin see indexes
SQL
1 vote137 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote139 views1 answer
Jenkins SQLCMD run
SQL
2 votes138 views1 answer
Sql column values comma separated
SQL
14 votes144 views2 answers
Oracle export trigger ddl
SQL
1 vote148 views1 answer
Oracle create_program
SQL
2 votes133 views1 answer
Postgresql update sequence next value
SQL
0 vote144 views1 answer
Jdbc sql connection string
SQL
1 vote138 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote144 views1 answer
Cast float mysql
SQL