title: Oracle SQL: the insert query with REGEXP_SUBSTR expression is very long ( split string )
body: <p>I must insert into table 2 fields (first the Primary key(about the articles) and the second concerns their size(of these articles).</p>
  
  <p>In source envrionnement, i have into  table, the primary key(TK Articles) and a concatenation of a size into second field. However, i must insert into target table, the TK Articles and the several size of the Artcles.
  For example,</p>
  
  <p>Source:                                                                                  </p>
  
  <pre><code>ART        SIZE**                                      
  1        |  28/30   
  2        |  30/32   
  3        | Size 10/Size 12/Size 14/Size 14
  </code></pre>
  
  <p>Target:</p>
  
  <pre><code>ART         Size
  1        |   28  
  1        |   30                   
  2        |   30            
  2        |   32             
  3        |  Size 10         
  3        |  Size 12       
  3        |  Size 14      
  3        |  Size 16
  </code></pre>
  
  <p>The difficulty is to know how many '/' is included in the field?</p>
  
  <p>I have made a query </p>
  
  <pre><code>SELECT ART,
         REGEXP_SUBSTR(SIZE,'[^/]+',1,level)
  FROM TABLLE
  CONNECT BY REGEXP_SUBSTR(SIZE,'[^/]+',1,level) IS NOT NULL;
  </code></pre>
  
  <p>the select transaction works and display results in 46 seconds. But the TABLE have 100 000 lines and  the insert transaction is too long and doesn't work.</p>
  
  <p>Somebody can help me on this point?</p>
  
  <p>Thanks &amp; Regards</p>