Sqlplus spool trim column whitespace. By default, sqlplus cuts off each line at 160 characters. Mar 3, 2017 · Trim is not working. This is the expected result 01JHON BROWN 30RED 02MARIO ROSSI 25WHITE this is my result 01 Apr 2, 2010 · I’m using SQL*Plus to spool a table to a csv file, but the default setting is to extract using fixed width. The directory name will not be known until run-time. g. txt'. csv SELECT * FROM EMP; SPOOL OFF Output is as Sep 25, 2016 · SPOOL OFF SET TERM ON The scripts/relations. The script is spool &spool_file select Col1 from Table1 where Col3 = 'Y'; spool off; exit; And it I would like to run as sqlplus user/pass@sid @my_script 'e:\AHD Desc\logs\My_file. Jan 14, 2020 · I've a problem with a sqlplus spool (oracle 12c/18c). We need to trim this column off all spaces, tabs or whatever white characters.