Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLcl 20.2 places two blank lines at top of CSV file

JaysonSep 14 2020 — edited Sep 14 2020

Hi folks,

I'm finding a strange issue in which SQLcl 20.2 in explicably places two blank lines at the top of any CSV file I create using SET SQLFORMAT CSV / SPOOL myfile.csv.

Here is a simple set of commands that produce the behavior:

SET ECHO OFF

SET SQLFORMAT CSV

SPOOL myfile.csv

SELECT * FROM SOME_TABLE;

EXIT

Using identical commands doesn't do this in SQLcl 18.2 or 17.3.

This is running from the command line on Red Hat Enterprise Linux 7.8.

Am I missing something or doing something wrong without realizing it? Thanks for any help anyone can give.

Comments
Post Details
Added on Sep 14 2020
1 comment
485 views