Skip to Main Content

SQL Developer

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!

Spaces stripped from column names in CSV format

2933897Oct 7 2025 — edited Oct 7 2025

SQL Developer 24 removes spaces from column names when formatting query results as CSV. The issue does not affect manual export or the SQL command line utility, only “Script Output” window and spool files.

SET SQLFORMAT CSV
SELECT
CURRENT_DATE AS "Date today"
, 'Value' AS "Column Name"
FROM DUAL
;

Output (v24.3.1.347):
"Datetoday","ColumnName"
07-Oct-2025 15:02:52,"Value"

Output (v22.2.0.173):
"Date today","Column Name"
07-Oct-2025 15:04:26,"Value"

Comments
Post Details
Added on Oct 7 2025
0 comments
95 views