Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: External tables - rejected rows

Re: External tables - rejected rows

From: gazzag <gareth_at_jamms.org>
Date: 31 May 2006 09:26:33 -0700
Message-ID: <1149092793.578944.245940@j55g2000cwa.googlegroups.com>


Chuck wrote:

>

> Rejected rows aren't included in the count, so the difference would
> always be 0.

No, I meant something like:

select count(*) into external_table_count from external_table;

Then, after your insert:

rejected_rows = external_table_count - sql%rowcount Received on Wed May 31 2006 - 11:26:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US