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 vote159 views2 answers
Sqlalchemy default value for column
SQL
0 vote150 views1 answer
Sql select all records from all tables where not empty
SQL
1 vote122 views1 answer
Sql server 2016 reseed identity
SQL
0 vote167 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote131 views1 answer
The local psql command could not be located
SQL
3 votes147 views3 answers
Stop mysql service ubuntu
SQL
0 vote180 views1 answer
DATEDIFF minute postgres
SQL
1 vote150 views1 answer
How to select multiple columns from different tables in mysql
SQL
2 votes130 views1 answer
Mysql list users on ubuntu
SQL
0 vote141 views1 answer
Select password from user mysql
SQL