title: Insert a Row using execute Immediate
body: <p>The below pl/sql showing error, because of the quotes. Can you please help ? And can you give me tips how to write this type of queries.</p>
  
  <pre><code>DECLARE 
  v_RULE_NAME VARCHAR2(200):='ABC';
  v_user_id NUMBER:=2;
  begin
  execute immediate 'INSERT INTO BW_TXS 
                   VALUES ('||TXN_ID.NEXTVAL||','||v_user_id||','
                           ||SYSDATE||',''super '''||v_RULE_NAME
                           ||',''super '''||v_RULE_NAME||')';
  
  end;
  </code></pre>
  
  <p>Thanks</p>