title: Update multiple columns using for all
body: <p>I am trying to update columns using for all. The set part of the update statement is constructed and then passed to the for all statement. There can be multiple columns in the set part.But it throws error : "missing equal sign". Any other method to solve this?</p>
  
  <pre><code>DECLARE
      V_COL_LIST VARCHAR2(4000);
      type emp_t
      IS
      TABLE OF NUMBER;
      emp_id emp_t;
  BEGIN
      SELECT employee_id bulk collect
      INTO emp_id
      FROM employees
      WHERE department_id=10;
  
      V_COL_LIST:='SALARY=EMPLOYEE_ID';
  
      FORALL INDX IN 1..emp_id.count
      UPDATE EMPLOYEES SET V_COL_LIST
      WHERE EMPLOYEE_ID=emp_id(indx);
  END;
  </code></pre>