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
Post a Comment