Update statement

• Set clause items fit into one line

  • Items in the same line as SET keyword

  UPDATE employees 
  SET    department_id = 70,dname = 'sales',location = 'ca' 
  WHERE  employee_id = 113; 

  • Items in new line, indent from 0 to n

  UPDATE employees 
  SET    
    department_id = 70,dname = 'sales',location = 'ca' 
  WHERE  employee_id = 113; 

• Stacked set clause items

  • Items in the same line as SET keyword

    • Comma in the end of line

      UPDATE employees 
      SET    department_id = 70,
             dname = 'sales',
             location = 'ca' 
      WHERE  employee_id = 113; 

    • Comma in the begin of line

      UPDATE employees 
      SET    department_id = 70
             ,dname = 'sales'
             ,location = 'ca' 
      WHERE  employee_id = 113; 

    • Comma in the begin of line, align items.

      UPDATE employees 
      SET    department_id = 70
            ,dname = 'sales'
            ,location = 'ca' 
      WHERE  employee_id = 113; 

    • Comma in the begin of line, align items. space between comma and item is 1 or n

      UPDATE employees 
      SET    department_id = 70
           , dname = 'sales'
           , location = 'ca' 
      WHERE  employee_id = 113; 

  • Items in new line, indent from 0 to n

    • Comma in the end of line

      UPDATE employees 
      SET    
        department_id = 70,
        dname = 'sales',
        location = 'ca' 
      WHERE  employee_id = 113; 

    • Comma in the begin of line

      UPDATE employees 
      SET    
        department_id = 70
        ,dname = 'sales'
        ,location = 'ca' 
      WHERE  employee_id = 113; 

    • Comma in the begin of line, align items.

      UPDATE employees 
      SET    
        department_id = 70
       ,dname = 'sales'
       ,location = 'ca' 
      WHERE  employee_id = 113; 

    • Comma in the begin of line, align items. space between comma and item is 1 or n

      UPDATE employees 
      SET    
         department_id = 70
       , dname = 'sales'
       , location = 'ca' 
      WHERE  employee_id = 113;