Home » SQL & PL/SQL » Client Tools » Format issue with NULL values (12.1.0.2.0)
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.
Previous Topic: Connect to Oracle DB using Oracle SQL Developer
Next Topic: How to export tnsnames.ora from Sql Developer
Goto Forum:
  


Current Time: Tue Nov 24 12:21:36 CST 2020