Skip to content

Indentation if statement

Tako Lee edited this page Mar 12, 2014 · 4 revisions

Original SQL:

IF (x < 7) THEN
IF (y < 0) THEN
<statements>
END IF;
ELSIF (x > 10) THEN
<statements>
ELSE
<statements>
END IF;

Formatted SQL:

Option: fmt133_indent_if_body = 4, type: TFmtInt.

Option: fmt145_indent_elsif_body = 3, type: TFmtInt.

Option: fmt139_indent_else_body = 3, type: TFmtInt.

IF (x < 7) THEN
   IF (y < 0) THEN
      <statements>
   END IF;
ELSIF (x > 10) THEN
   <statements>
ELSE
   <statements>
END IF;

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

Clone this wiki locally