Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Commit after a select query

920466Feb 28 2012 — edited Feb 29 2012
Do we need to commit after a select statement in any case (in any transaction mode)?

Why do we need to commit after selecting from a table from another databse using a DB link?

If I execute a SQL query, does it really start a transaction in the database?
I could not find any entry in v$transaction after executing a select statement which implies no transactions are started.

Regards,
Sandeep
This post has been answered by unknown-7404 on Feb 28 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2012
Added on Feb 28 2012
8 comments
7,954 views