title: How i can pass column names from variables in plsql update statement
body: <pre><code>DECLARE
  
    v_name  A.TRANSACTION_TYPE%TYPE   :='SALARY';
    v_salary    A.SALARY%TYPE := 1000;
  
  BEGIN
  
    update A set v_name= v_salary where EMPID = 517; 
  -- PL/SQL: ORA-00904: "v_name": invalid identifier
  --update A set SALARY = 1000 where EMPID = 517;
  
  END;
  
  /
  </code></pre>
  
  <p>My idea is to update table columns , but these column names are stored in variable. Is there any way to pass column names from variable ? Is there any options apart from Execute Immediate</p>