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

13 votes181 views3 answers
Sql online code
SQL
8 votes225 views2 answers
Update sql server from another table
SQL
0 vote197 views1 answer
Sintaxis SELECT sql
SQL
0 vote202 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote202 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote186 views2 answers
MySQL top percent
SQL
27 votes205 views3 answers
Mysql show tables in database
SQL
2 votes203 views2 answers
Mysql find max value row
SQL
1 vote163 views2 answers
Delete auto increment mysql
SQL
1 vote229 views2 answers
Postgres select from last 3 months
SQL