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 Version 19.4.0.354.1736 format rules works for FORMAT BUFFER and doesn't work for FORMAT FILE

User800507-OracleFeb 19 2020 — edited Mar 5 2020

A very simple format rule

<options>

<breaksComma>oracle.dbtools.app.Format.Breaks.Before</breaksComma>

</options>

works for format buffer but doesn't work for format file.

Download attached test.zip, unzip it and than run

sql.exe any_user/password @test.run

and you will see that format buffer works fine while format file works with default rules.

Comments

Post Details

Added on Feb 19 2020
3 comments
453 views