Skip to content

Align the IN and OUT keywords of parameter declaration

Tako Lee edited this page Mar 12, 2014 · 1 revision

Align the IN and OUT keywords in columns when defining the interface for a procedure or function.

Original SQL:

Option: fmt092_align_parameter_in_out = false, type: TFmtBoolean.

PROCEDURE Days_Between (dStartDate IN date,
                        dEndDate IN date,
                        nGPA IN OUT number,
                        nDaysBetween OUT number)

<procedure declarations and body>

Formatted SQL:

Option: fmt092_align_parameter_in_out = true, type: TFmtBoolean.

PROCEDURE Days_Between (dStartDate   IN     date,
                        dEndDate     IN     date,
                        nGPA         IN OUT number,
                        nDaysBetween    OUT number)

<procedure declarations and body>

Reference: http://www.dba-oracle.com/t_plsql_code_alignment_standards.htm

Clone this wiki locally