OraFAQ Forum: Client Tools » Format issue with NULL values

Home » Other » Client Tools » Format issue with NULL values (12.1.0.2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Format issue with NULL values [message #682021]

Sun, 27 September 2020 02:38

zooby2doo
Messages: 1
Registered: September 2020

Junior Member

Hi,

I need to create a spool file in CSV format. like "col1";"col2";"col3";..."col80"

with SET MARKUP CSV ON DELIMITER ';' option I can get desired results only for non null columns.

if I use set null '""' then i get required format "" (2 double quotes) only for null columns in number datatype but for the case of varchar datatype i get """""" (6 double quotes).

Could you please advise how to get "" (2 double quotes for null values for varchar datatype column)

Thanks.

Report message to a moderator

Previous Topic:	Connect to Oracle DB using Oracle SQL Developer
Next Topic:	How to export tnsnames.ora from Sql Developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 30 18:52:42 CST 2024