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: <MfwEwkCtzVem_at_spammotel.com>
Date: Wed, 07 Nov 2007 07:35:06 -0800
Message-ID: <1194449706.524079.231570@k79g2000hse.googlegroups.com> 





> It might unless one were to consider that ROWID is a reserved word in

> Oracle with a very specific meaning.




Huuu...right...


I tried select * from (select rownum rn from table where
rownum<=recno) where rn=recno,


but with 100.000.000 rows its awfully slow!



Martin
Received on Wed Nov 07 2007 - 09:35:06 CST












Original text of this message













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