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

1 vote229 views1 answer
Postgresql not in
SQL
0 vote200 views1 answer
Char varchar nvarchar sql
SQL
5 votes206 views3 answers
Mysql extract month from date
SQL
0 vote203 views1 answer
Conda install pymysql "windows"
SQL
3 votes202 views1 answer
Mysql load sql from file
SQL
9 votes221 views6 answers
Sql insert into
SQL
0 vote225 views1 answer
Sql server isnull function nor working count
SQL
3 votes209 views1 answer
Convert sqlite table to pandas dataframe
SQL
2 votes205 views2 answers
Select list is not in group by clause
SQL
0 vote209 views1 answer
Less mysql display
SQL