RE: ** commit or rollback - diff

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <ajoshi977@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 12 Feb 2009 16:38:59 -0500

Rollback is safer just incase you did a DML transaction without knowing
it like inside a procedure.
 

Dick Goulet 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of A Joshi
Sent: Thursday, February 12, 2009 4:32 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: ** commit or rollback - diff 


Hi, 
    If I have not done a dml transaction in a session : no update,
delete or insert etc. I have only done select and some of the objects
can be over a db link. So I can do a commit or rollback so that no
transaction is pending in my session. My question is : is there any
difference in such case between the behaviour of commit and rollback.
When there is no data as such to commit or rollback.  I am thinking it
is better to do rollback since it has to do less. Am I wrong. Any
observation. Thanks for help. Thanks    

Other related posts: