Forum Stats

  • 3,758,210 Users
  • 2,251,354 Discussions
  • 7,870,110 Comments

Discussions

sqlcl and json format

user10621655
user10621655 Member Posts: 3 Green Ribbon
edited May 27, 2018 4:37PM in SQLcl

Hi,

I'm new with Sqlcl.

I'm trying to export a table with case-sensitive column name, but the spool in json format put column name in lower-case

{"results":[{"columns":[{"name":"colOne","type":"VARCHAR2"},{"name":"colTwo","type":"VARCHAR2"}],"items":

[

{"colone":"1234567890","coltwo":"TestValue"}

]}]}

the database version is 11.2.0.4.0

SqlCl version: 18.1.1.0

Any suggestions?

It is a bug ?

Thanks in advance

Francesco

Answers