When typing the following query in Microsoft Word
select * from
where = ‘value’;
and pasting it into Toad's Editor. When it is executed, the following error is returned.
"ORA-00911: invalid character"
Discovered that it had to do with the single quote being interpreted differently in Toad vs. Word. How can that be changed in Toad?
The same issue can be seen in other Quest products, like Toad Data Point and SQL Navigator. However, non-Quest products, like SQL PLUS from command line, also does not work. Same problem goes with Oracle SQL Developer.
If pasted from Word to Notepad, there is a difference between the single quote in MS Word vs. the single quote in Notepad.
