SELECT rows range from a view?

From: Giovanni Azua <bravegag_at_hotmail.com>
Date: Sat, 1 Jun 2002 04:06:00 +0300
Message-ID: <ad9ahf$ujsjq$1@ID-114658.news.dfncis.de>

Hi all,

How can one retrieve only rows X to Y from a *VIEW*?

I know it is possible using the ROWID and ROWNUM but what from a complex view?

SELECT *

        FROM   tableX
        WHERE  rowid in (
           SELECT rowid FROM tableX
           WHERE rownum <= 7
          MINUS
           SELECT rowid FROM tableX
           WHERE rownum < 5);

but if TableX is a VIEW I get the error: cannot select ROWID from a join view without a key-preserved table

Thanks in advance,
Giovanni Received on Fri May 31 2002 - 20:06:00 CDT