queries to get data in batches from a huge data table
DIVIJan 3 2013 — edited Jan 3 2013HI,
Here is my problem, i need to create some files with my own format(let say 5000 recs each) from a huge data table (May contain 5 Million records). And i want this creation to be multi threaded.
so how can i form queries efficiently to fetch records like 1..5000 and 5001..10000 and so on.
I can form some thing like select * from table where rownum<5000 and not exists ( already fetched records) . but it is not the efficient one. . please suggest me the best way of forming the queries or any alternative approach to create files.
Edited by: DIVI on Jan 3, 2013 7:39 AM