How to limit query count 1

[mars19301]

Using TOAD, I am querying a very large file, but only want the data for the first 100 records to review. Is there a way to do this?

Thank you in advance for all advice. m

 

[SantaMufasa]

How about:

select * from <table>
 where rownum <= 100

Let us know if this works for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Beilstwh]

if you want to see a random selection of rows use

select * from my_table
where rownum <= 100;

if you want to see the first 100 rows of a sorted list use

select * from
(select * from my_table
order by my_col)
where rownum <= 100;


Bill
Oracle DBA/Developer
New York State, USA