Oracle rollback

-- 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 vote124 views1 answer
Sqlite show columns in table
SQL
1 vote120 views1 answer
Random name function in mysql for nvarchar
SQL
1 vote108 views1 answer
How to delete record sql delphi
SQL
1 vote118 views1 answer
Convert rows to string sql server
SQL
6 votes132 views3 answers
Update with inner join postgres
SQL
1 vote128 views1 answer
Sysdate in sql
SQL
0 vote118 views1 answer
Drop all data from tables
SQL
11 votes74 views1 answer
Reset identity sql server
SQL
2 votes117 views1 answer
Sql to char function with date
SQL
2 votes128 views1 answer
Use cases condition in sql query laravel
SQL