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!

How do I compress the output?

SteveBJun 11 2018 — edited Jun 25 2018

Hi.

(Using sqlcl 18.1 on 11.2.0.4)

In sqldev I can compress a json 'export' of a table. In sqlcl I can set the sqlformat to json - which is awesome. I can't see how I can also compress. I want to dump a 90M row table in json format and I'd really prefer to zip it on the way out.

Is this possible?

Thanks,

Steve

Added on Jun 11 2018

6 comments

1,064 views