/SQL/Oracle transaction commit rollback example

Oracle transaction commit rollback 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

4 votes156 views1 answer
Sql quote in string
SQL
0 vote143 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
0 vote156 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
1 vote170 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote152 views1 answer
Mysql get first 2 characters of string
SQL
1 vote134 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote136 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
3 votes147 views3 answers
Postgresql random number
SQL
0 vote131 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
3 votes146 views1 answer
Sql replace character in string in all records
SQL