title: CAST and CONCAT inside INSERT
body: <p>Using an Oracle database :</p>
  
  <p>How can I use a concatenation and cast inside an INSERT statement ?</p>
  
  <p>I need to insert data for some tests, and I need to change the ID of the inserted data.</p>
  
  <p>So far, I got this :</p>
  
  <pre><code>BEGIN
    FOR i IN 100..400 LOOP
        INSERT INTO PRESTATION 
        (ID_DEMANDE, ID_PRESTATION, CODE_PRODUCTEUR_UNICITE_PRESTA, SELECTION, ID_RUBRIQUE, LIBELLE_CONTRAT, CODE_PRODUCTEUR_ENTITE_JURIDIQ, GUICHET_GESTIONNAIRE, CODE_SOURCE, CODE_PRODUIT, CODE_SOUS_PRODUIT, LIBELLE_PRODUIT, CODE_BANQUE, NUMERO_CLIENT, MONTANT, DEVISE, RESEAU_DISTRIBUTION, DATE_OUVERTURE, DATE_FERMETURE, ROLE) 
        VALUES 
        ('DO20161220160056000592', CONCAT('0000000317501820134', CAST(i AS VARCHAR)), '00020', 'O', 0, 'COMPTE  COURANT', '30003', '03175', '001', '020', '001', 'COMPTE D ENTREPRISE', '30003', '00000013419', '4242,420', 'EUR', '10', '27/01/93', '31/12/99', '10');
    END LOOP;
  END;
  </code></pre>
  
  <p>I probably need to add a SELECT somewhere.</p>
  
  <p>Or there's probably a better way to generate those IDs...</p>