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 and json format

user10621655May 24 2018 — edited May 27 2018

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

Comments

Processing

Post Details

Added on May 24 2018
4 comments
655 views