SQL preview indentation sql block

Jump to bottom Edit New page

Tako Lee edited this page Apr 9, 2014 · 2 revisions

Body of stored procedure
- Block without BEGIN/END keyword (sqlid:10218050)
  - fmt127_indent_procedure_body (default:2)
- Block with BEGIN/END (sqlid:10218109)
  - fmt128_indent_procedure_body_begin_keyword_in_newline
    - false
    - true
      - fmt129_indent_procedure_body_begin_keyword(default:2)
  - fmt130_indent_procedure_body_end_keyword_in_newline
    - false
    - true
      - fmt131_indent_procedure_body_end_keyword(default:2)
  - fmt132_indent_procedure_body_block_inside_begin_end(default:2)
Body inside if/while/loop statement
- Block without BEGIN/END keyword(sqlid:10218160)
  - fmt133_indent_if_body (default:4)
  - fmt145_indent_elsif_body (default:3)
  - fmt139_indent_else_body (default:3)
- Block with BEGIN/END (sqlid:10218202)
  - fmt134_indent_if_body_begin_keyword_in_newline
    - false
    - true
      - fmt135_indent_if_body_begin_keyword(default:2)
  - fmt136_indent_if_body_end_keyword_in_newline
    - false
    - true
      - fmt137_indent_if_body_end_keyword(default:2)
  - fmt138_indent_if_body_block_inside_begin_end(default:2)

PP V3 format options