This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,693 Users
  • 2,269,776 Discussions
  • 7,916,823 Comments

Discussions

Specify Line Terminator in SQLcl Export

user11339984
user11339984 Member Posts: 1
edited May 26, 2016 9:59AM in SQLcl

Hello,

Does anyone know how I can specify the Line Terminator to be Unix/Max LF when I export using the delimited format using sqlcl? It currently adds CRLF at the end of each record. I would like to have it export LF instead.

Thanks!

Craig Elliott

Answers

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Master Product Manager NC, USAPosts: 8,927 Employee
    edited May 26, 2016 9:59AM

    it uses the OS default, but you can change it

    script

      2  var FormatRegistry = Java.type("oracle.dbtools.raptor.format.FormatRegistry");

      3  FormatRegistry.setLineTerminator("     ");

      4  /

    Or maybe don't use beer emojis, but use \t

    Craig Elliott