SQL Formatter Options

Stored Procedure Variables

Three alignment options for the variable declarations and assignments in procedural code. A declaration block with aligned data types reads like a table, which makes an omitted or mistyped declaration easy to spot.

Stored Procedure Variables

Variables

ID	Option	What it does	Default
ID051	ProAlign Variable Declarations ALI_DECLARATION	Aligns the data types of variable declarations into a column. A declaration block then reads like a table, and an omitted type is obvious.	`on`
ID137	ProAlign Variable Association Operatorts (=>) ALI_ASSOCIATIONOPERATOR	Aligns the named-parameter operator in procedure calls, so that parameter names and their values form two columns.	`on`
ID140	ProAlign Variable Assignment Operators (:=, =:, =, =) SP_ALI_ASSIGNMENT	Aligns assignment operators, so that the assigned expressions start at a common column.	`on`

An aligned declaration block reads like a table – an omitted or mistyped declaration is then obvious.

ID051 off, ID140 off

declare
    v_emp_nbr integer;
    v_employee_name varchar2(60);
    v_salary number(9,2);
begin
    v_salary := 0;
    v_employee_name := 'unknown';

ID051 on, ID140 on

declare
    v_emp_nbr       integer;
    v_employee_name varchar2(60);
    v_salary        number(9,2);
begin
    v_salary        := 0;
    v_employee_name := 'unknown';

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.