From: hillmw@ram.lmtas.lmco.com   
      
   "Mark C. Stock" wrote:   
   >   
   > "Michael Hill"  wrote in message   
   > news:40479F09.C62F9BE4@ram.lmtas.lmco.com...   
   > | I have some query like:   
   > |   
   > | select my_field from my_table   
   > |   
   > | and there are 500000 rows in the table, how do I tell Oracle to display   
   > | the next 33?   
   > |   
   > | i tried select my_field from my_table next 33 and it doesn't like it.   
   > |   
   > | Mike   
   >   
   > are you familiar with the WHERE clause?   
   >   
      
   yes and so using the where clause gets me from 500000 rows to 25000   
      
   > what version of oracle are you using?   
   >   
      
   Dont know for sure at least 8. something I think.   
      
   > what is your interface (tool)?   
   >   
      
   I am using perl dbi and so I'd like to limit the number number of   
   records using the query statement. Some tools do that for you as does   
   coldfusion.   
      
   > ;-{ mcs   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)