Line Feed and Carriage return Characters from Oracle table to Unix flat file
Does SQL*Plus have any SET parameter which will eliminate the action taken when the OS intercepts line feeds or Carriage Return characters of data transferred from a table column (a select statement) redirected to a flat file. Currently, the out file will have a number of short lines with blank lines inserted at the end and sometimes between the short lines. The short lines are a result of line feeds and the blank lines are a result of carriage returns. I would like for the OS to ignore the line feeds and carriage returns and just place the column data
0