Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Avoid Empty Quoted Strings for NULL Varchar/Char data while exporting to csv

User_TMQWIJul 28 2021

I'm using PUT_LINE_NCHAR to write data into csv's
here I can see that NULL strings are written in csv's as empty quoted string ("") for char and varchar columns and for int type columns I can see empty unquoted string in csv (blank/zero length)
Now, I want to avoid those empty quoted string for NULL data of char and varchar columns instead need unquoted empty string

how can I achieve???

Thanks in advance

Comments

Processing

Post Details

Added on Jul 28 2021
0 comments
233 views