Where clause

• Condition in the same line as WHERE keyword

  Option: fmt017_where_condition_in_newline = false, type: TFmtBoolean.

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  e.department_id = d.department_id  

  • AND/OR keyword at the end of line

  Option: fmt019_where_condition_andor = at_the_end_of_line, type: TFmtANDOR.

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  e.department_id = d.department_id AND
         e.last_name = 'Matos';  

  • AND/OR keyword at the begin of line, align with condition

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  e.department_id = d.department_id
         AND e.last_name = 'Matos';  

  • AND/OR keyword at the begin of line, align with WHERE keyword

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  e.department_id = d.department_id
    AND  e.last_name = 'Matos';  

• Condition in new line, indented from 1 to n

  Option: fmt017_where_condition_in_newline = true, type: TFmtBoolean.

  Option: fmt018_where_condition_indent = n, type: int.

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  
    e.department_id = d.department_id  

  • AND/OR keyword at the end of line

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  
    e.department_id = d.department_id AND
    e.last_name = 'Matos';  

  • AND/OR keyword at the begin of line, align with condition

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  
    e.department_id = d.department_id
    AND e.last_name = 'Matos';  

  • AND/OR keyword at the begin of line, align with WHERE keyword

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  
      e.department_id = d.department_id
  AND e.last_name = 'Matos';