SQL preview SQL Parameters

Jump to bottom Edit New page

Tako Lee edited this page Apr 10, 2014 · 5 revisions

Parameter declaration
- Parameter style(sqlid:10099814)
  - fmt151_parameter_list_style
    - fit_into_one_line
    - stacked
      - fmt152_parameter_list_comma_option
        
        before_item_outside_list_with_n_space
        
        fmt153_parameter_list_comma_space(default:1)
- Style of parameter list block(sqlid:10099814)
  - fmt154_parameter_list_start_parenthesis_in_newline
    - false
    - true
      - fmt155_parameter_list_start_parenthesis_indent(default:2)
  - fmt156_parameter_list_end_parenthesis_in_newline
    - false
    - true
      - fmt157_parameter_list_end_parenthesis_indent (default:2)
  - fmt158_parameter_list_first_item_in_newline
    - false
    - true
      - fmt159_parameter_list_first_item_indent (default:2)
- Align data type(sqlid:10099814)
  - fmt160_parameter_list_align_data_type
    - false
    - true
- Align the IN and OUT keyword(sqlid:10099886)
  - fmt092_align_parameter_in_out
    - false
    - true
Parameter in function call
- SQL function(sqlid:10099916)
  - Parameters style
    - fmt085_function_call_parameter_list_style
      - fit_into_one_line
      - stacked
        
        fmt086_function_call_parameter_list_comma_option
        
        before_item_outside_list_with_n_space
        
        fmt087_function_call_parameter_list_comma_space(default:1)
- PL/SQL Parameters in function call(sqlid:10099947)
  - fmt093_align_plsql_function_call_parameter
    - false
    - true

PP V3 format options