Re: Limiting Large Result Sets

smartnhandsome@xxxxxxxxx wrote:
working ENV:
Jdeveloper 10.1.3 - Development
Oracle 9i - Database
Windows XP - OS

I want to retrieve about 30 rows at a time . The table contains over 2
million rows. I would like to begin at the first row and drag 30 rows
over the network. Then get the next 30 and repeat the process untill
all rows are displayed.

Any other suggestions are also acceptible.

Try look at rownum !

http://www.oracle.com/technology/oramag/oracle/06-sep/o56asktom.html

Arne
.

Relevant Pages

  • Re: Oracle 10g startup problem
    ... I installed Oracle 10g in my computer (windows XP). ... the database did not start automatically. ... VMware Server, and on ESX Server. ...
    (comp.databases.oracle.server)
  • RE: connect to oracle database as sysdba form windows
    ... Is the Unix user in the dba group? ... Is the Oracle server local on Unix but remote from Windows, or vice versa, ... Is the Windows user in the ORA_DBA group if it's local? ... the remote_password_file parameter on the database is the one to look at, ...
    (perl.dbi.users)
  • Re: Theoretical Question OracleService
    ... Have a fairly good understanding of the OS where your Oracle software ... On Windows, you need a service to run a process in the background i.e. ... the other threads eventually end up in i.e. database, ... Open up another DOS session and start ...
    (comp.databases.oracle.server)
  • Re: How to Change ini.ora filename on Windows?
    ... Windows NT: ... Oracle8i uses the initialization parameter files located ... initialization file with the PFILE option at database startup." ... the Oracle 8i documentation. ...
    (comp.databases.oracle.server)
  • Re: Email Connectivity
    ... > I am currently researching for my dissertation ... > I intend to build a database that amongst other things will record ... > handling the emails so long as oracle can access the data including ... > windows xp pro PC at home and a Windows 2000 pro PC at University. ...
    (comp.databases.oracle.misc)