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 vote280 views1 answer
Least spark sql
SQL
0 vote276 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
7 votes270 views2 answers
Mysql get year from date
SQL
0 vote250 views1 answer
Oracle search in date columns
SQL
0 vote250 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote265 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote271 views2 answers
Tsql row number
SQL
1 vote284 views1 answer
Spark sql convert string to date
SQL
5 votes297 views1 answer
Mysql where one year ago
SQL
1 vote280 views1 answer
T-sql find object by name
SQL