Re: selecting specified rows from a view using rownum

From: Jörn Fieg <fieg_at_wmd.de>
Date: 1997/12/02
Message-ID: <34845F2A.BDEC133C@wmd.de>#1/1

--------------81865EF6F3CC2EBA3BBF2591
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi Frank

Frank Curti wrote:

>  I am working on a web based application using Netscapes Livewire and Oracle
> 7.3.  I create a view based on a query and I need to be able to get 25 rows
> at a time.  When I make the following query it does not work.
>
> select * from view1 where rownum <= 50 intersect select *
>                                          from view1 where rownum >= 25;
>
> The Oracle documentation is pretty clear why it does not work(it says the
> second select statement assigns a rownum value equal to 1 which makes the
> rownum >= 25 statement false) but does not tell me how to work around the
> problem.  Can I some way still use rownum or is there a way I can insert
> another column into the view?

> Thanks in advance,
> Frank Curti

How about:

select * from view1 where rownum <= 50
minus
select * from view1 where rownum <= 25;

Not really performat, but working.

CU, Jörn

--------------81865EF6F3CC2EBA3BBF2591
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<HTML>

Hi Frank

Frank Curti wrote:
<BLOCKQUOTE TYPE=CITE> I am working on a web based application using
Netscapes Livewire and Oracle
 7.3.  I create a view based on a query and I need to be able to
get 25 rows
 at a time.  When I make the following query it does not work.

select * from view1 where rownum <= 50 intersect select *
                                         
from view1 where rownum >= 25;

The Oracle documentation is pretty clear why it does not work(it says
the
 second select statement assigns a rownum value equal to 1 which makes
the
 rownum >= 25 statement false) but does not tell me how to work around
the
 problem.  Can I some way still use rownum or is there a way I
can insert
 another column into the view?</BLOCKQUOTE>

<BLOCKQUOTE TYPE=CITE>

Thanks in advance,
 Frank Curti</BLOCKQUOTE>

 How about:

select * from view1 where rownum <= 50
 minus
 select * from view1 where rownum <= 25;

Not really performat, but working.

CU, Jörn</HTML>

--------------81865EF6F3CC2EBA3BBF2591-- Received on Tue Dec 02 1997 - 00:00:00 CST