How to fix the Oracle error DRG-10861: COMPLETION score must be used with WITHIN operator?

In this post, you’ll learn more about the Oracle ErrorDRG-10861: COMPLETION score must be used with WITHIN operator with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-10861: COMPLETION score must be used with WITHIN operator

Reason for the Error DRG-10861: COMPLETION score must be used with WITHIN operator

Cause: The completion score is used without using the WITHIN operator

How to fix the Error DRG-10861: COMPLETION score must be used with WITHIN operator ?

You can fix this error in Oracle by following the below steps

Action: Rewrite query to include a within operator