PLSQL developer adding quotes when we copy the data in SQL window result grid

[Karthi S]

Hello there,

I am using PLSQL developer 12 version (12.0.7.1837).

When I run some select SQL in the SQL window, I get the SQL output in the grid. But when I copy the rows and paste into any text editor, each line from the grid is getting paste in a strange format.

It is adding a double quotes at the beginning, and then a newline character and double quotes at the end (when I paste it in textpad I see total number of lines are doubled).

It is really annoying. Can you please let me know if any preference or some setting causing that issue?

Thanks,
Karthi.

 

[Marco Kalter]

The quotes are added when special characters are in the field data. In this case it seems that the field data includes newline characters. Can you verify this? In this case you can perhaps use the replace() or substr() function to remove the extra newline chr(10) characters.

 

[Karthi S]

Hi Marco,
Thanks for your response. Yes, I realized there are special characters. That's why those quotes are getting added. Once I removed those special characters it looks good when I copy and paste the SQL results to a text editor.