title: Apex_Collections - How do I loop through an apex collection of arrays
body: <p>I have a collection of array's, currently the code</p>
  
  <pre><code>select apex_collections.c001 from apex_collections where collection_name = 'LOAD_CONTENT'
  </code></pre>
  
  <p>Shows the below on screen.</p>
  
  <blockquote>
    <p><strong>C001</strong></p>
    
    <p>570</p>
    
    <p>571</p>
  </blockquote>
  
  <p>I have another table called errorTable that has a column Table1ID that matches with the values contained within the C001 array. I need to display all the records within the errorTable to the user where there is a match. In this example I want to show all records in errorTable where Table1ID match '570' or '571'.</p>
  
  <p>I'm thinking I need to do a loop through the apex_collections C001 array and then do something like select * from errorTable where apex_collections.c001(i) = errorTable.Table1ID</p>
  
  <p>I'm trying to get help on how to write this loop as I'm struggling a bit with that.</p>