Skip to content

Space inside parenthesis of expression

Tako Lee edited this page Mar 11, 2014 · 3 revisions
  • No space

    Option: fmt096_space_padding_expression_parenthesis = false, type: TFmtBoolean.

    SELECT (((a - b) - c))  
    FROM   t 
  • One space

    Option: fmt096_space_padding_expression_parenthesis = true, type: TFmtBoolean.

    SELECT (( ( a - b ) - c ))  
    FROM   t  
  • Do not use spaces between multiple parentheses or semicolons (;). Always precede the first opening parenthesis of a set with a space.

    Option: fmt096_space_padding_expression_parenthesis = false, type: TFmtBoolean.

    AND (((x < 5) AND (y < 5))
    OR   ((x > 5) AND (y > 5)));

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

Clone this wiki locally