SQL Formatter Options

Procedure & Function Parameters

The parameter list in the header of a stored procedure or function is its public interface. These options place the brackets and the commas of that list, so that every parameter with its mode and data type occupies its own line.

Proceddure / Function Parameters

Linebreaks

ID	Option	What it does	Default
ID078	ProLinebreak Before Comma SP_LBB_COMMA	Leading commas in the parameter list: the comma opens the line of the parameter that follows.	`on`
ID079	ProLinebreak After Comma SP_LBA_COMMA	Trailing commas in the parameter list.	`on`
ID100	ProLinebreak Before '(' SP_LBB_OPENPARMBRACKET	Puts the opening bracket of the parameter list on a new line, separating it from the procedure name.	`on`
ID101	ProLinebreak After '(' SP_LBA_OPENPARMBRACKET	Starts the first parameter on the line after the opening bracket.	`on`
ID102	ProIndent Parameter in Brackets SP_IND_PARMBRACKET	Indents the parameters one level deeper than the procedure name.	`on`
ID103	ProLinebreak Before ')' SP_LBB_CLOSEPARMBRACKET	Puts the closing bracket on a new line, where it terminates the signature.	`on`
ID104	ProLinebreak After ')' SP_LBA_CLOSEPARMBRACKET	Starts whatever follows – `RETURNS`, `AS`, `IS` – on the line after the closing bracket.	`on`
ID245	ProMove Comma 2 Positions to the left with 1 Space (When ID10... SP_ALI_MOVE_COMMALEFT_PARM	Shifts a leading comma two positions left and puts one space after it.	`off`
ID246	ProMove Comma 1 Position to the left with no Space (When ID10... SP_ALI_MOVE_COMMALEFTONE_PARM	Shifts a leading comma one position left with no space after it.	`off`

The parameter list is the public interface of the procedure. One parameter per line, with mode and data type aligned, makes it readable as a signature.

All off

create procedure raise_salary (p_emp_nbr in integer, p_pct in number, p_result out varchar2) as

ID100, ID101, ID102, ID103, ID104 on

create procedure raise_salary
(
    p_emp_nbr in  integer,
    p_pct     in  number,
    p_result  out varchar2
)
as

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.