Home » Other » Client Tools » Format issue with NULL values (
Format issue with NULL values [message #682021] Sun, 27 September 2020 02:38
Messages: 1
Registered: September 2020
Junior Member

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)

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

Current Time: Wed May 29 01:44:20 CDT 2024