Expressions
Last modified: 29 November 2022File | Settings | Editor | Code Style | SQL | <SQL Dialect> | Expressions for Windows and Linux
IntelliJ IDEA | Preferences | Editor | Code Style | SQL | <SQL Dialect> | Expressions for macOS
Ctrl+Alt+S 
Configure code style for corteges, binary expressions, the CASE clause, and procedure calls.
Cortege
Item | Description |
|---|---|
Add space before '(' | Add space before the opening parenthesis ( |
Space within parentheses | Add a space after the opening parenthesis and before the closing parenthesis. |
Place comma to begin | Move a comma to a new line. |
Space before comma | Add a space before a comma. |
Space after comma | Add a space after a comma. |
Binary expression
Item | Description |
|---|---|
Use spaces around operators | Add a space before and after an operator. |
Align operands in binary expressions | Align operands in binary expressions. |
Space between parenthesized sub-expressions | Add a space after the opening parenthesis and before the closing parenthesis in sub-expressions. |
Function or procedure call
Item | Description |
|---|---|
Space within parentheses | Add a space after the opening parenthesis and before the closing parenthesis |
Space before comma | Add a space before a comma. |
Space after comma | Add a space after a comma. |
CASE clause
Item | Description |
|---|---|
Wrap WHEN | Move WHEN to a new line. |
Indent WHEN if wrapped | Add an indent before WHEN if the Wrap WHEN option is selected. |
Wrap THEN | Move THEN to a new line. |
Align THEN | Align all THEN keywords in CASE clauses. |
Align ELSE under THEN when THEN aligned | Align ELSE under THEN when THEN is aligned. |
Align END | Align END in CASE clauses.
|
Keep new line after THEN, ELSE | Add a new line after THEN and ELSE. |
Collapse short clause | Join multiline short clauses. The length of a clause that will be collapsed is determined automatically by IntelliJ IDEA. |
Thanks for your feedback!