SQL*Plus (MOSC)

MOSC Banner

Line Feed and Carriage return Characters from Oracle table to Unix flat file

edited Jun 25, 2009 5:56AM in SQL*Plus (MOSC) 1 commentAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center