In the SQL Editor in Oracle's excellent SQL Developer tool, if you are running queries using an Oracle Text Index, you will run into issues when using the CONTAINS operator and searching for terms such as ${MySearchTerm}. The dollar-bracket syntax is used to do stemmng, but the SQL editor interprets them as bind variables and prompts you for their value. To turn off the bind variable interpretation you can precede the SQL statement with the following command:
set define off;
You only need to do this once and it will remain in effect for the rest of your usage of that SQL worksheet.
About Me
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment