Skip to content

Align oracle PLSQL operators

Tako Lee edited this page Mar 7, 2014 · 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.

    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