title: Checking for a particular string format in Oracle 11g
body: <p>In Oracle 11g, I need to check perform a check to see if the following format is true (i.e. via a regular expression):</p>
  
  <pre><code>PaaaaE0%
  PaaaaD2%
  </code></pre>
  
  <p>where this value is of the following format:</p>
  
  <pre><code>P ( followed by any 4 alphanumeric digits) E or D (followed by atleast 1 numeric digit)
  </code></pre>
  
  <p>As part of the 4 alphanumeric digits, if alpha then they need to be uppercase.</p>
  
  <p>For now, I have tried something like:</p>
  
  <pre><code>REGEXP_LIKE('PWOOOE12s3','[P][:alnum:]{4}[ED][:digit:]{1}')
  </code></pre>