Re: ROWNUM problem...

...you can use a view to do this, try the following:

create view vwtest as select rownum the_rownum,name from yourcolumn

...now you can make a 'subselection' with the query:

select * from vwtest where the_rownum between 10 and 20

However, now you probably will run into problems when you want to retrieve a sorted selection.

Succes anyway Received on Mon May 04 1998 - 02:18:54 CDT