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

0 vote179 views1 answer
Find and replace database table phpmyadmin
SQL
1 vote184 views1 answer
Oracle sql create view
SQL
12 votes180 views1 answer
Docker mysql random root password
SQL
0 vote207 views1 answer
Oracle string length
SQL
3 votes192 views2 answers
Oracle apex view logs
SQL
0 vote172 views1 answer
Postgresql create table with boolean column
SQL
0 vote186 views1 answer
Postgresql delete type
SQL
1 vote218 views1 answer
Psql view enum values
SQL
0 vote189 views1 answer
Oracle table privileges
SQL
0 vote187 views1 answer
Stored procedures example
SQL