Thursday, December 26, 2013

Example to show Insert command needs to be Commited




Step 1: Login to the database as User “Sur” and create a table as shown below.
Step 2: Insert a row into the table as shown below.
Step 3: As user Sur, you will be able to see the row inserted in the above step before committing.
Step 4: From another terminal, if you login as another user, say SYS, and try to see the contents of Friends table, you will not see any rows.
Step 5: Once the user Sur commits the transaction, SYS will be able to see the contents.