title: How to remove hidden double quotes in column values of SQL Developer
body: <p>Some of the column values in my table are enclosed within double quotes and I need to remove those double quotes. The problem is, I am not able to view the double quotes symbol in SQL Developer (version 4.2.0.16.260). But when I copy the data to Notepad++, there I am getting double quotes. I tried <code>instr</code> to get the position of double quotes, its returning the result 0. Also I tried to replace double quotes with blank, but they are not being removed.</p>
  
  <p>Below is the data I see when copied to Notepad++. 2 records are displayed. I'm trying to take the distinct value from these 2 values. But I am not able to. </p>
  
  <pre><code>"Testdata
  "
  
  Testdata
  </code></pre>