Skip to content

Align parameters in function call

Tako Lee edited this page Mar 7, 2014 · 2 revisions

When calling a procedure or function, align the parameters into a column. This reduces the visual clutter around the call, making it stand out from the rest of the code.

Original SQL:

Option: fmt093_align_plsql_function_call_parameter = false, type: TFmtBoolean.

DaysBetween (dStartDate => dEnrolledDate,
             dEndDate => dGraduationDate,
             nGPA => nFinalGPA,
             nDaysBetween => nDuration);

Formatted SQL:

Option: fmt093_align_plsql_function_call_parameter = true, type: TFmtBoolean.

DaysBetween (dStartDate   => dEnrolledDate,
             dEndDate     => dGraduationDate,
             nGPA         => nFinalGPA,
             nDaysBetween => nDuration);

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

Clone this wiki locally