sql - What does COMMIT do? -


please want understand difference between folowing 2 statements:

insert table_name values (,,,,,); 

and

insert table_name values (,,,,,); commit; 

if insert data without commit can select data database , see it. other users can't.

it's better sql documentation:

until commit transaction:

you can see changes have made during transaction querying modified tables, other users cannot see changes. after commit transaction, changes visible other users' statements execute after commit.

you can roll (undo) changes made during transaction rollback statement (see rollback.

for example here oracle documentation , info transactions


Comments

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

javascript - jQuery date picker - Disable dates after the selection from the first date picker -