Skip to main content
2 of 8
added 266 characters in body
Andy
  • 1
  • 2

Is there anyway to search PL/SQL reserved words with contains function in the Oracle?

Is there anyway to search PL/SQL reserved words with contains function in the Oracle?

I should explain more. We would like to search keywords such as "test for" or "test do" with contains or catsearch function from user table in the Oracle but the results only show for "test" and ignore those reserved words such as "do" or "for" etc automatically.

eg. contains(text, 'test for') > 0

Thanks

Andy
  • 1
  • 2