title: How to convert negative and comma separated values to numbers oracle?
body: <p>I have values like -</p>
  
  <p>43,042 <br>
  - 1<br>
  44,889<br>
  35,224<br>
  - 1,000<br>
  17,683<br></p>
  
  <p>and the data type is obviously varchar 2.</p>
  
  <p>I have to put a condition in the column to select values above 5000 but I am unable to convert it to number due to presence of commas and negative signs.
  How can I convert it to number to perform this check.</p>
  
  <p>Thanks in advance.</p>