title: How to convert a string to number in PL/SQL
body: <p>I have 5 character string which can have numbers, decimal points, alphabets and spaces. I wanted to convert this string to a number (integer) if all the characters in string are numbers. i.e.</p>
  
  <ul>
  <li>No decimal points allowed</li>
  <li>No +/- sign allowed</li>
  <li>Spaces are not allowed in between but they can be allowed at extremes</li>
  </ul>
  
  <p>Thanks in advance.</p>