SQL Formatter Options

My Lists for SQL Functions

Some function calls hold long argument lists that deserve their own layout – a DECODE with twenty branches, an IN list of literals, a COALESCE across many columns. Here you can name up to three groups of function keywords and give each group its own formatting, independent of the general list options.

My List for SQL Functions 1

IDOptionWhat it doesDefault
ID194FreeMy SQL Function Keywords GROUP 1
MY_FUNCTIONKEYWORDLIST		The function keywords of group 1, one per line. Argument lists inside these functions are formatted with the settings below instead of the general list options.in
ID196FreeNumber of Values in 1st Line
LB_NBR_COMMASINFUNCTIONLIST_L1		How many arguments appear on the first line. Setting this higher than the following lines lets you keep the function name and its first arguments together.
Choices: 1, 2, 3, 4, 5, 6, 7, 8, 10, 20, 100, 999		1
ID197FreeNumber of Values in subsequent Lines
LB_NBR_COMMASINFUNCTIONLIST		How many arguments appear on each subsequent line.
Choices: 1, 2, 3, 4, 5, 6, 7, 8, 10, 20, 100, 999		1
ID225FreeLinebreak Before (
LBB_FUNCTIONLIST1_OPENBRACKET		Puts the opening bracket of the function call on a new line.off
ID228FreeLinebreak After (
LBA_FUNCTIONLIST1_OPENBRACKET		Starts the first argument on the line after the opening bracket.off
ID198FreeAlign Commas
ALI_COMMA_FUNCTIONLIST		Aligns the commas of the argument list into a column.off
ID231FreeIndent Values inside Bracket
IND_FUNCTIONLIST1		Indents the arguments one level deeper than the function name.off

ID194 contains decode; ID197 = 2 puts two arguments on each subsequent line, so the branches of the decode pair up.

decode not listed in ID194
select decode(status, 1, 'new', 2, 'open', 3, 'done', 'other')
from   ticket
decode listed, ID197 = 2
select decode(status,
              1, 'new',
              2, 'open',
              3, 'done',
              'other')
from   ticket

My List for SQL Functions 2

IDOptionWhat it doesDefault
ID199FreeMy SQL Function Keywords GROUP 2
MY_FUNCTIONKEYWORDLIST2		The function keywords of group 2, one per line. Use a second group when different functions need different argument layouts.(empty)
ID200FreeNumber of Values in 1st Line
LB_NBR_COMMASINFUNCTIONLIST2_L1		How many arguments appear on the first line.
Choices: 1, 2, 3, 4, 5, 6, 7, 8, 10, 20, 100, 999		1
ID201FreeNumber of Values in subsequent Lines
LB_NBR_COMMASINFUNCTIONLIST2		How many arguments appear on each subsequent line.
Choices: 1, 2, 3, 4, 5, 6, 7, 8, 10, 20, 100, 999		1
ID226FreeLinebreak Before (
LBB_FUNCTIONLIST2_OPENBRACKET		Puts the opening bracket on a new line.off
ID229FreeLinebreak After (
LBA_FUNCTIONLIST2_OPENBRACKET		Starts the first argument on the line after the opening bracket.off
ID202FreeAlign Commas
ALI_COMMA_FUNCTIONLIST2		Aligns the commas of the argument list.off
ID232FreeIndent Values inside Bracket
IND_FUNCTIONLIST2		Indents the arguments one level deeper than the function name.off

A second, independent group – here in with ID201 = 2 and ID232 on.

in not listed in ID199
where dept_nbr in (10, 20, 30, 40, 50, 60)
in listed, ID201 = 2, ID232 on
where dept_nbr in (
          10, 20,
          30, 40,
          50, 60
      )

My List for SQL Functions 3

IDOptionWhat it doesDefault
ID203FreeMy SQL Function Keywords GROUP 3
MY_FUNCTIONKEYWORDLIST3		The function keywords of group 3, one per line.(empty)
ID204FreeNumber of Values in 1st Line
LB_NBR_COMMASINFUNCTIONLIST3_L1		How many arguments appear on the first line.
Choices: 1, 2, 3, 4, 5, 6, 7, 8, 10, 20, 100, 999		1
ID205FreeNumber of Values in subsequent Lines
LB_NBR_COMMASINFUNCTIONLIST3		How many arguments appear on each subsequent line.
Choices: 1, 2, 3, 4, 5, 6, 7, 8, 10, 20, 100, 999		1
ID227FreeLinebreak Before (
LBB_FUNCTIONLIST3_OPENBRACKET		Puts the opening bracket on a new line.off
ID230FreeLinebreak After (
LBA_FUNCTIONLIST3_OPENBRACKET		Starts the first argument on the line after the opening bracket.off
ID206FreeAlign Commas
ALI_COMMA_FUNCTIONLIST3		Aligns the commas of the argument list.off
ID233FreeIndent Values inside Bracket
IND_FUNCTIONLIST3		Indents the arguments one level deeper than the function name.off

A third group – here coalesce with one argument per line and the commas aligned.

coalesce not listed in ID203
select coalesce(bonus, commission, allowance, 0)
from   employee
coalesce listed, ID205 = 1
select coalesce(bonus,
                commission,
                allowance,
                0)
from   employee

Tip: The three groups are independent and are matched by function name. A function that appears in none of them falls back to the general list options on the Comma Separated Lists page.

Option IDs are identical across all SQLinForm editions (VS Code, JetBrains, SSMS, Notepad++, Online Formatter) and are the keys stored inside a profile file. Generated from properties.json 2026.8.21.0.