Some headers are missing characters and one of the row with a lot of text is spilling into the next column. Cant use set markup csv on due to version. Opened the csv file in vscode and the spilling issue wasn’t there but the headers where still missing characters.
Column FORMAT A also isn’t working even if I set it to A10000 after about 500 characters it still spills over to the next column.
The file does need to be opened in excel and I wont be the one making use of it so I cant just ignore it either.
This is my first time using sql*plus so I’m already out of ideas
Here are the settings I am using, any help would be much appreciated.
SET PAGESIZE 50000
SET LINESIZE 32767
SET TRIMSPOOL ON
SET TRIMOUT ON
SET COLSEP ,
SET UNDERLINE OFF
SET HEADING ON
SET HEADSEP OFF