New reserved names

Formatter does not recognize the reserved name "ANY_VALUE".
Please add new reserved names, introduced in Oracle 12+.

Hi Ihor,

If it's causing a problem formatting a query, can you provide an example?

If it just needs to be colorized, you can add it to the list here:

Hi John

  1. I added the value “ANY_VALUE” to the list of keywords. However, the Formatter's behavior remained the same. When formatting, ‘ANY_VALUE’ remains in uppercase, whereas, for example, “COUNT” is converted to lowercase.

  2. My Formatter settings:

[Qp5FormatterOptions]
Version=397
OutputTabs=4
IndentSize=4
RightMargin=120
LF_SQLOthers=0
KeywordCase=2
VariableCase=1
BuiltInCase=2
BuiltInPackageCase=2
AssignAlignment=2
ParensStyle=0
Tagline=0
DmlColumnAliasAlignment=0
DmlTableRefAliasAlignment=0

Hey Ihor,
This is fixed in coming release.
Thanks!

Thank you @milos.lekovic !