Question

How do I spool EACH row result from a single SELECT sql statement to different output file?

SELECT * FROM myTable WHERE columnId < 45;

while (rs.next(){
result of row1 goes to row1.txt;
result of row2 goes to row2.txt;
result of row3 goes to row3.txt;
result of row4 goes to row4.txt;
}