RE: When we commit a transaction what sort of things h...
when we commit a transaction we cannot undo any information in that transaction.
once commit has been happened in any transaction oreacle server saves all changes done by us and again it wont give permission to us to do any alter or modification
RE: When we commit a transaction what sort of things happen in the oracle server ?
Ends the current transaction by making all pending data changes permanent. Is the simplest way to define. Transaction means start with an DML SQL Statement and end with one of the following 1) A commit or rollback statement is issued or 2) DML OR DCL Statement executes (AUTO COMMIT) or 3) The System crashes.
