Hi,
I'm trying to write content of oracle table into a csv file for one of my task.
First i tried to add the column name into csv file followed by writing the column value into the csv file.
But when i try to add my column name to csv file its showing only my last column name value cos its overwriting existing column name value each time.
I'm confused about what a "column name value" is. I'm also confused about why your code doesn't actually write the contents of the table to the CSV file... is that what you are asking about?
Perhaps it would help if you showed an example of your output and explained why it was wrong?
Anyway you should do some debugging to see what your code is doing. Wait... I see you already are. But you haven't told us the results of that. Keeping your data secret isn't helpful. Tell us what you already found out.
Sorry Paul,
I attached my output file with my previous reply. But it was somehow missed... Once again sorry because it was not accepting csv and xls file as attachment.
I hava four columns(sku_code,sku_upc,list_price,sale_price) in my table.
Paul Clapham wrote:Anyway you should do some debugging to see what your code is doing. Wait... I see you already are. But you haven't told us the results of that. Keeping your data secret isn't helpful. Tell us what you already found out.
Hi Paul,
Finally i got answer for my question. As you said i did some more debug with my code and modified it slightly to get the expected result for my task.