title: Q-Quote in execute immediate PL/SQL
body: <p>I have following Update statement:</p>
  
  <pre><code>UPDATE COL_VAL SET DESC_VALUE=q'['TOM','JOHN','MARIE','VANI','PUTIN']' WHERE TYPE_NAME||TYPE='OLDHOL' ;
  </code></pre>
  
  <p>When I put above q-qoute in execute immediate, PL/SQL is not able to recognize syntax.</p>
  
  <pre><code>DECLARE
  upd_stmnt varchar2(4000);
  BEGIN
      upd_stmnt := q'[UPDATE COL_VAL SET DESC_VALUE=q'['TOM','JOHN','MARIE','VANI','PUTIN']' WHERE     TYPE_NAME||TYPE='OLDHOL']';
  EXECUTE IMMEDIATE upd_stmnt;
  END;
  /
  </code></pre>
  
  <p>Please help.</p>