Oracle sql commit 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 vote336 views1 answer
Execut sql python
SQL
1 vote321 views1 answer
Sql injection
SQL
2 votes308 views3 answers
Mysql cheat sheet
SQL
0 vote368 views1 answer
Postgres list users and roles
SQL
33 votes338 views2 answers
Postgres how to add field created at
SQL
0 vote336 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
6 votes388 views1 answer
Oracle trigger after logon on database
SQL
2 votes358 views1 answer
Q operator in plsql
SQL
5 votes328 views1 answer
Oracle get nls settings
SQL
0 vote338 views1 answer
In mysql workbench contnent not feching
SQL