select counts versus insert/select counts

  • From: Michael.Coll-Barth@xxxxxxxxxxxxxxxxxxx
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 18 Oct 2007 15:49:33 -0400

All,

I came across a rather strange situation a few days ago.  One of our
developers wrote a simple sql script that inserted some rows into a
table.  However, he was getting things that were not expected.  He ran
just the select portion of the code and got a different number of rows.
Any thoughts on what it might be or what to search for?

We are running on AIX Version 5.2 with Oracle Database 10g Enterprise
Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options.  

Thanks,
Michael


The information contained in this message and any attachment may be
proprietary, confidential, and privileged or subject to the work
product doctrine and thus protected from disclosure.  If the reader
of this message is not the intended recipient, or an employee or
agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please notify me
immediately by replying to this message and deleting it and all
copies and backups thereof.  Thank you.

--
//www.freelists.org/webpage/oracle-l


Other related posts: