I know that the changes to tables in oracle database are temporary until we issue commit or rollback command. But one intersting this is that : I am using oracle 8i and when i log on to the database with user id scott and make some changes(delete or update) to the tables and exit oracle(sql plus) without issuing the commit command. Next time when i log on to oracle , i found the canges are permanent. how came this?
Are the changes meade to database permanent without issuing commit? is so..then what is the need of commit command?
Thank you
Enter your message below
Sign in or Join us (it's free).