When generating a csv file, how do you convert a NULL value to "" ? I do not want to change the developments. I would like to find a solution in the file format editor. Do you have an idea ?
The opposite is possible, i.e. using a certain value as null indicator. Not what you're looking for. You'll need to map your columns using nvl(<col>,'').
You could also specify a default value at database level for the columns in your target table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.