Hi,

Need help on exporting data to csv from oracle database
when i export ...
the field which has null values (in database) appear as 'null' word in the csv output.
Is there a way to avoid it?

thanks

What do you want it to do when it encounters a null value in the database?

hi,

I want it go as blank value ",," and not as ",null," values.

Thanks

Run it through a sed script to remove the "null" entries.

NULL is a real value in SQL, hence it gets exported as a real value.
If you want it replaced with something else, adjust the method that writes the output to do the replacement...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.