Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question on selecting rows in table
JohnO wrote:
> I need to select portions of a table for parallel processing, without
> relying on any data column in the table. Essentially, I need to create two
> (or more) datasets to have parallel program threads fetch against to run a
> process on every row in the table, while guaranteeing that no row is
> processed twice, and no row is missed. Is there a column like "ROWID", but
> numbered so I can do math on it, or a function of ROWID that will allow a
> select conditional to select mutually exclusive, collectively exhaustive
> portions of the table?
>
> Thanks!
I have a real problem when people write "I need to" followed by a description of what they "WANT" to do.
I would suggest that you restate the request as a business problem such as:
Because I take strong exception with the thought that you actually "NEED" to something in a specific way. Unless, of course, you are in a class and your instructor has made this a requirement and you want someone else to do your homework for you.
Daniel Morgan Received on Mon Nov 04 2002 - 14:20:40 CST