title: Oracle query looking for particular string format
body: <p>Am working with an Oracle 11g db in which I need to run a query that returns all rows with values in a specific format.</p>
  
  <p>I.e., I need to find all rows with a value like 'abc1234'. The actual values aren't important....what I need is to find all rows with the first 3 characters being alpha and the subsequent 4 characters all being numeric.</p>
  
  <p>Any input would be much appreciated.</p>