Re: SQL*PLUS CHALLANGE

Roya Mehrfar wrote:
>
> I have a sqlplus statement with an order by that I need to retrieve > only the first 25 rows. I tried where rownum < 26 but it trows away my > order by because I would like to do the order by first and then get > the first 25 rows.

Try rewriting your SQL*Plus statement as a cursor in PL/SQL.

-- 
===============================================================
Richard Bennett		E-Mail: richhb_at_sequent.com
				rbennett_at_teleport.com
Computer People Inc.	On contract to Sequent Computer Systems