title: String Pattern Matching in Sql / Pl/sql
body: <p>I need to match a string to a pattern to validate the given string.</p>
  
  <p>The given string could be like this 1234/5678.</p>
  
  <p>I should validate the string in such a way that the first four and the last four characters will have to be numbers and they must be seperated by a slash.</p>
  
  <p>How can I do this in SQL  or PL/SQL?</p>
  
  <p>I tried different functions such as REGEXP_LIKE, REGEXP_REPLACE,REGEXP_SUBSTR.</p>
  
  <p>Can anyone please help me on this?</p>