title: How to effectively search on a delimited string in Oracle?
body: <p>I have an Oracle 11g table setup as:</p>
  
  <pre><code>CODE   VERSION   STRING_DATA 
  AAA    1         aaa|bbb|EARTH|ddd|eee
  AAA    1         aaa|bbb|MARS|ddd|eee
  AAA    2         aaa|b22|EARTH|d22|eee
  BBB    1         aaa|b22|EARTH|d22|eee
  </code></pre>
  
  <p>Now the STRING_DATA is broken down as:</p>
  
  <ol>
  <li>col1 </li>
  <li>col2 </li>
  <li>location </li>
  <li>col4 </li>
  <li>col5</li>
  </ol>
  
  <p>How could I write a query similar to my psuedo-code?</p>
  
  <pre><code>SELECT *
  FROM MY_TABLE
  WHERE CODE = 'AAA' AND VERION = 1 AND LOCATION = 'EARTH
  </code></pre>