OCI-62243
Each predicate in HAVING clause must be in the format of 'APPROX_RANK(PARTITION BY ... ORDER BY ... DESC) <(=) n' when approximate top functions are used.
Cause
Illegal predicates were used in the HAVING clause when approximate top functions were used.
Action
Correct the format to 'APPROX_RANK (PARTITION BY ? ORDER BY ? DESC) <(=) n'.
OCI-62243
Each predicate in HAVING clause must be in the format of 'APPROX_RANK(PARTITION BY ... ORDER BY ... DESC) <(=) n' when approximate top functions are used.
Cause
Illegal predicates were used in the HAVING clause when approximate top functions were used.
Action
Correct the format to 'APPROX_RANK (PARTITION BY ? ORDER BY ? DESC) <(=) n'.
OCI-62243
Each predicate in HAVING clause must be in the format of 'APPROX_RANK(PARTITION BY ... ORDER BY ... DESC) <(=) n' when approximate top functions are used.
Cause
Illegal predicates were used in the HAVING clause when approximate top functions were used.
Action
Correct the format to 'APPROX_RANK (PARTITION BY ? ORDER BY ? DESC) <(=) n'.