I have one table which has got around 10 million records and
since this table is so big it takes a while to populate these records
reports. Instead i was thinking of a way to populate say first 1000
then the next 1000 records and so on. So is there any way to populate
within a given range, say populating first 1000 records and then
records from 1001-2000,2001-3000
and so on. I thought Rownum might help but it doesn't.
Can somebody help.