Re: How can I limit the NUMBER of rows returned?

You may want to try:

alter session set optimizer_goal = first_rows;

or

select /*+ FIRST_ROWS */ emp, ename from emp ...

(and the rownum < 100mentioned in prev. postings)

This is for cost based optimizer,

Best regards,

Toni

+--------------------------------------------------------------------+


| Anton Dischner, DBA and system-programmer    Phone: +49 89 70953202|


| Institut fuer Klinische Chemie               Fax  : +49 89 70958888|

| Klinikum Grosshadern                         Home : +49 89 6254060 |

| Ludwig Maximilians Universitaet Muenchen     Handy: +49 172 8388880|

| 81366 Muenchen                                                     |

| Marchioninistr. 15                                                 |

| Germany                          Mail: dischner_at_med.uni-muenchen.de|

+--------------------------------------------------------------------+