Skip to content

Align oracle PLSQL operators

shenhuan2021 edited this page Mar 3, 2024 · 6 revisions

Arrange series of statements containing similar operators into columns whenever it will not cause excessive white space and you have sufficient room to do so.

Delphi

  • gfmtopt.TrueLeft, type of boolean

Java

  • TODO

Uniform

  • Original SQL

    Option: fmt091_align_similar_operators = false, type: TFmtBoolean.

vFirstName := 'Roger';
vLastName := 'Smith';
vSSN := 999999999;
  • Formatted SQL:

    Option: fmt091_align_similar_operators = true, type: TFmtBoolean.

vFirstName := 'Roger';
vLastName  := 'Smith';
vSSN       := 999999999;

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

Clone this wiki locally