Hello,
I generate in SQL Developer version Version 17.4.0.355 files in CSV format (execute as SQL script).
The table has column values like
2-4 or 9/11, that is in CSV file displayed as 02. Apr.
I tried with
col testcol format 9999 or VARCHAR2 (VARCHAR)
,
but that did not work.
How set the right format commmand syntax that it is correctly displayed as varchar in Spool output format CSV file?
Thanks for help.
I don't believe this is a SQL Developer issue, but an Excel one.
It is Excel that looks at data and "automagically" decides if the incoming data should become a date.
You can avoid this by doing
- starting Excel
- choose "Get Data from Text"
- the Text Import wizard appears
- in step 3, change "general" to "text" for those columns that might be a problem.
(I'll double check with the SQL Developer PM to see if there is anything we can do at our end)