ROWNUM question

From: <rspeaker_at_my-deja.com>
Date: Thu, 07 Oct 1999 20:27:22 GMT
Message-ID: <7tivmp$8pq$1@nnrp1.deja.com>

I have a table with just under 1.5 MM records in it, and wanted to insert a subset of those columns and data to another table. I realize PL/SQL would be the most efficient way to do this, but at this point, is not my forte'. I chose to do it in chunks using SQL*Plus.

I first issued insert into tab1 (select * from tab2 where rownum < 100000); to get the first 100,000 records. No problem. I then issued insert into tab1 (select * from tab2 where rownum between 100001 and 250000); and got 0 records. Then I tried insert into tab1 (select * from tab2 where rownum >100000 and rownum <= 250000); and again got 0 records. Finally I truncated tab1 and did insert into tab1 (select * from tab2 where rownum <= 250000); and got 250,000 records.

Can anybody tell me why? Is there something magical about rownum that you cannot use it in compound comparisons?

Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 07 1999 - 15:27:22 CDT