RE: select counts versus insert/select counts

I see several responses out there, which we will look into and I will get back.

As to the SQL, without giving you the tables and the data, I am not sure it would really help. We are having difficulties getting the problem to consistently replicate, even when using same data and tables in different schemas. Obviously, we will need something that we can go to Oracle with, but I was looking for general ideas to pursure rather than trying everything.

The SQL statement was basically of this form;

insert into tablex
(
 a, b, c, d
)
select a, b, c, d
from tabley y,

     tablez z
where y.key = z.key
;

The number of rows 'select'ed is different than the number of rows 'insert'ed when the code is cut and pasted into a SQL prompt.   

> -----Original Message-----
> From: Tanel Poder
>
> This is a kind of post where the actual SQL statements would
> be *really*
> handy.
>

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