title: EXECUTE IMMEDIATE with multiple lines of columns to insert
body: <p>just want to get an idea if this is the correct way to do an EXECUTE IMMEDIATE with multiple columns and lines and assigning it to a variable?  I tried looking at examples but am not sure if I am concatenating the lines correctly?</p>
  
  <pre><code>sql_stmt        VARCHAR2(200);
  
  sql_stmt:='INSERT INTO (STORECODE, TILLID, TRANSACTIONNR, TRADINGDATE, TRANSTYPE, ' ||
            'OPERATORCODE TRAININGMODE, VOIDED, VALUEGROSS, VALUENETT, VALUEDUE) ' ||
            ‘VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10)’;
            EXECUTE IMMEDIATE sql_stmt USING sSTORECODE………………………………………..fGROSS_AMOUNT,
        ‘0’;   
  </code></pre>