How to limit oracle table search?

venkata ramani

New Member

Join Date: Oct 2011

Posts: 1
#1

How to limit oracle table search?

Oct 13 '11, 07:09 AM

when i put a query like select * from my table it will be running/scrolling continuously as there are many records in the table but I want to stop it and see the data in the table for limited records. what is the query ? and how can stop scollin
Tags: None
johny10151981

Top Contributor

Join Date: Jan 2010

Posts: 1059
#2

Oct 13 '11, 09:29 AM

this link must have to help you

Last edited by Niheel; Oct 14 '11, 04:51 AM. Reason: Johny, if you can post part of the solution with the link. That would be much more helpful.
Comment
Rabbit

Recognized Expert MVP

Join Date: Jan 2007

Posts: 12517
#3

Oct 13 '11, 03:19 PM

Code:

SELECT * FROM someTable WHERE ROWNUM < 101
Comment

Comment