Re: A few simple Oracle questions

On Wed, 01 Apr 1998 22:22:38 -0800, "Mark W. Eaton" <eaton_at_best.com> wrote:

>Our organization is relatively new to Oracle but fairly seasoned with SQL Server
>development. We have a few questions we need to understand to make the
>transition as quickly as possible. Please respond directly via email as I do
>not read this newsgroup regularly,
>
>Sincerely,
>Mark Eaton
>eaton_at_best.com
>
>-----------------------------------------------------------------------
>SQL*Plus related
>--------------------------
>How do I tell the Server to return only a fixed number of rows in response to a
>query.
>In isql (Sybase) I would say
>set rowcount 10
>select fld1 from table1 where fld2 > 100
>This would return the first 10 rows that fulfilled the condition.
>How do I achieve the same in SQL*Plus. There does not seem any
>environment variable that I can set.

Just a week ago this was discussed excessiv in this group. Check dejanews archive for 'Tricky SQL Problem: Top "n" of queried records'

Here's Tzads propossel(I think there was another good on from Juri): Received on Fri Apr 03 1998 - 00:00:00 CST