Re: limiting number of records retrieved

In article <1l8t10INN20o_at_hsc.usc.edu> mcitron_at_hsc.usc.edu (Mark Citron) writes:
>
>I need to limit the number of rows returned by a query using standard sql (in
>sqlrep - i want to limit the number of rows listed in the interests of space)
>
>Any suggestions would be appreciated.
>Mark Citron
>
>--
>Mark Citron
>mark_at_neurosci.usc.edu
>

Two ideas:

Select Columns from table where
ROWNUM < MAX_ROWS_YOU_WANT_TO_RETRIEVE

The Oracle rownum keyword assigns sequential numbers to the rows returned by a query.

You can also use the resource limiter in Oracle7 to kill long running queries or those that return too many rows.

Hope this helps,

• Dan

Daniel Druker
Anderson Graduate School of Management at UCLA                    

| Dan Druker                                                               |
| agsm mail 	: ddruker                                                  |
| internet 	: ddruker_at_agsm.ucla.edu                                    |
| oracle*mail	: unix:ddruker_at_agsm.ucla.edu                               |
----------------------------------------------------------------------------

Disclaimer: None. I'm a student now and I don't care what you think. Received on Tue Feb 09 1993 - 22:18:18 CET