Re: reading random records with JDBC?

On Nov 5, 4:27 am, <MfwEwkCtz..._at_spammotel.com> wrote:
> > Use the SAMPLE clausehttp://www.psoug.org/library.html
> > scroll down to "SAMPLE CLAUSE."
>
> Thank you very much for your good idea!
> But I did not tell the whole truth: I want to read random records from
> two tables and compare them. So I read record 883 from table1 and
> record 883 from table2 and compare the fields. Then I continue with
> another record.
>
> Martin

There are no records in a database, only rows.

So exactly what is the key that makes the rows comparable? Use that. IOW, select a sample from table 1 and fectch the rows with the same keys from table 2, and then compare.

 HTH,
  ed Received on Wed Nov 07 2007 - 12:37:25 CST