SQL function

• Parameters

  • Fit into one line

    Option: fmt085_function_call_parameter_list_style = fit_into_one_line, type: TFmtListStyle.

    SET @a = dbo.Func1(@param1, @param2, @param3 + 1, @param4) 

  • Stacked parameters

    Option: fmt085_function_call_parameter_list_style = stacked, type: TFmtListStyle.

    • Comma at the end of line

      Option: fmt086_function_call_parameter_list_comma_option = after_item, type: TFmtCommaOption.

      SET @a = dbo.Func1(@param1, 
                         @param2, 
                         @param3 + 1, 
                         @param4) 

    • Comma at the begin of line

      SET @a = dbo.Func1(@param1
                         ,@param2 
                         ,@param3 + 1
                         ,@param4) 

    • Comma at the begin of line, align parameters

      SET @a = dbo.Func1(@param1
                        ,@param2 
                        ,@param3 + 1
                        ,@param4) 

    • Comma at the begin of line, align parameters, space between comma and space is 1 or n

      Option: fmt086_function_call_parameter_list_comma_option = before_item_outside_list_with_n_space, type: TFmtCommaOption.

      Option: fmt087_function_call_parameter_list_comma_space = n, type: int.

      SET @a = dbo.Func1( @param1
                        , @param2 
                        , @param3 + 1
                        , @param4) 

• Decode function

  SELECT last_name, 
         DECODE(job_id, 'It_prog', 1.10 * salary, 
                        'st_clerk', 1.15 * salary, 
                        'sa_rep', 1.20 * salary, 
                        salary) revised_salary 
  FROM   employees;