The way I know is to use a cursor for loop, andThat's pretty much it, yeah.
inside this for loop, generate your csv output line
by line, manually inserting a ', ' in between the
fields, then use utl_file.put_line to write the
result to a text file.
If I remember correctly,Only if you were opening and closing the file inside the loop, which would be a bit of a silly thing to do.
you'll need to open the file in append mode so
subsequent writes in the for loop won't overwrite
previous results (otherwise you'll only get one
tags to format your example - this is not the complete code. Where is the cursor defined? Regards Marcus