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

Home -> Community -> Usenet -> c.d.o.misc -> Re: reading random records with JDBC?

Re: reading random records with JDBC?

From: Ed Prochak <edprochak_at_gmail.com>
Date: Tue, 27 Nov 2007 21:00:27 -0800 (PST)
Message-ID: <efcc46f0-3f08-4641-97ca-25dc3fd73062@d4g2000prg.googlegroups.com>


On Nov 27, 5:08 pm, "йенс мартин шлаттер" <MfwEwkCtz..._at_spammotel.com> wrote:
> > The sample clause was mentioned before - how about
> > reading from table A, using SAMPLE, and searching
> > for corresponding entries from b (preferably using
> > the primary key on B)?
>
> This is a very good idea, thank you!
> But it means that the program has to find out what the primary key is
> and which type it is. But it could work.
>
> JMS
Aha! He can be taught!

With the Primary Key, you searches will be MUCH faster. This is the direction I clumsily tried to lead you toward.

You do not care what the type of the PK columns are. For there to be corresponding rows the types must just match between the tables. For you to compare rows, you must alredy know the columns are of the same type.

Much better.
  Ed Received on Tue Nov 27 2007 - 23:00:27 CST

Original text of this message

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