insert into ... select ... returns different number of rows as select ...
boffmanApr 8 2009 — edited Apr 8 2009Hi,
I'm runing a package with an "insert into table1 select ... " statement and it inserts less records into table1 as the same select statement - runing alone - rows returns (Same user, no synonyms, no other transaction accessing objects) ? The only unusual thing is that the select statement works like:
select ...
from (select ... from ...) x
, table2 y
, table3 z
where ...
Can it be a bug in 10g because of the second select statement in the from clause?
cheers,
Bernhard