SQL logical condition operator AND OR option

AND/OR option is used to set format option of AND/OR operator in condition.

Type definition

• Type name: TFmtANDOR
• Available values:
  • value: 0, text: at_the_end_of_line
  • value: 1, text: at_the_begin_of_line
  • value: 2, text: at_the_begin_of_line_outside
  • value: 3, text: at_the_begin_of_line_left_align_with_main_keyword
  • value: 4, text: at_the_begin_of_line_right_align_with_main_keyword

Samples

• AND/OR 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 at the begin 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';