What's after FETCH nnn rows.
Posted: Sat Oct 03, 2020 5:37 pm
Hi Friends,
I've a huge table in production. Which I need to unload. It's taking a lot of time to unload this table. I thought to unload it in 'pieces' like unload some rows of it then rest of it. To do that, I used FETCH FIRST nnnnn rows from the table, this is order by a column. But now how do I unload rest of the table of next set of 'nnnnn' from the table?
Can someone please let me know.
I've a huge table in production. Which I need to unload. It's taking a lot of time to unload this table. I thought to unload it in 'pieces' like unload some rows of it then rest of it. To do that, I used FETCH FIRST nnnnn rows from the table, this is order by a column. But now how do I unload rest of the table of next set of 'nnnnn' from the table?
Can someone please let me know.