I have dcs_sku table .The record count is 50 thousand in that table.My requirement is to fech every row,create an xml out of it and post the data to some third party.
As the count is very huge,I can't select the entire record and do the operation at a time.
Can some one please suggest an way by which I will run the sql query in a loop,which will fetch 1st from rown 1 to row 1000,next 1001 to 2000,2000 no 'n' row...
I tried the below query:
select * from dcs_sku where rownum between 1 and 200...This gave me the 1st 200 rows and worked fine.
but the moment I changed the query to :
select * from dcs_sku where rownum between 201 and 300:::No result was coming up.
I am very new to sql and this is a very very imp thing that I have to deliver to client asap.
So please helppppppppppppppppppppppppppppppppppppppppppppppp