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 vote136 views1 answer
Postgres 11 add primary key
SQL
1 vote155 views1 answer
Psql connect to another database
SQL
14 votes140 views1 answer
Sql value of string
SQL
0 vote136 views2 answers
Identity syntax in sql
SQL
1 vote130 views1 answer
Data type and their numeric form
SQL
1 vote174 views1 answer
Mysql print variable
SQL
1 vote140 views2 answers
Snowflake alter column data type
SQL
5 votes128 views4 answers
Describe table postgres
SQL
0 vote127 views1 answer
Create function syntax sql server
SQL
-1 vote132 views3 answers
Create temp table in sql
SQL