RE: select counts versus insert/select counts

This is a kind of post where the actual SQL statements would be *really* handy.

The issue you have is probabaly not about Oracle returning wrong rowcounts but the developer *expecting* wrong rowcounts.

Like this case with NULLs for example:

SQL> create table t(a int);

Table created.

SQL> insert into t values(null);

1 row created.

SQL> select count(*) from t;

  COUNT(*)

         1

SQL> select count(a) from t;

  COUNT(A)

         0

--
Regards,
Tanel Poder
http://blog.tanelpoder.com
 



> -----Original Message-----

> From: oracle-l-bounce_at_freelists.org 

> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of 

> Michael.Coll-Barth_at_VerizonWireless.com

> Sent: Friday, October 19, 2007 03:50

> To: oracle-l_at_freelists.org

> Subject: select counts versus insert/select counts

> 

> 

> 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.

> 

> --

> http://www.freelists.org/webpage/oracle-l

> 

> 


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