title: Bulk Collect Oracle
body: <p>Can bulk collect be done if data is getting inserted into table A from Table B and while selecting data, substr, instr, trunc functions has been used on columns fetched?</p>
  
  <pre><code>INSERT INTO A
  SELECT
  DISTINCT 
      SUBSTR(b.component, 1, INSTR(b.component, ':', 1)  - 1),
      TRUNC(c.end_dt, 'DDD'),
  FROM 
      B b,
      C c
  WHERE 
      TRUNC(c.end_dt)=TRUNC(b.last_Date, 'DDD') ;
  </code></pre>
  
  <p>How can I insert data into table A using bulk collect?</p>