title: Oracle REGEX functions
body: <p>I am working on Oracle 10gR2.</p>
  
  <p>I am working on a column which stores username. Let's say that one of the values in this column is "Ankur". I want to fetch all records where username is a concatenated string of "Ankur" followed by some numerical digits, like "Ankur1", "Ankur2", "Ankur345" and so on. I do not want to get records with values such as "Ankurab1" - that is anything which is concatenation of some characters to my input string.</p>
  
  <p>I tried to use REGEX functions to achieve the desired result, but am not able to.</p>
  
  <p>I was trying:</p>
  
  <pre><code>SELECT 1 FROM dual WHERE regexp_like ('Ankur123', '^Ankur[:digit:]$');
  </code></pre>
  
  <p>Can anyone help me here?</p>