RE: select counts versus insert/select counts
- From: Michael.Coll-Barth@xxxxxxxxxxxxxxxxxxx
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Oct 2007 10:45:33 -0400
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
