Use instead of != or ~=
PLS-01472 – Oracle Error Code
In a set_function_specification- if DISTINCT is present- the expression must be a column_specification
PLS-01471 – Oracle Error Code
The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr)
PLS-01470 – Oracle Error Code
The escape character in the like-predicate must be a literal or a variable of type CHAR
PLS-01469 – Oracle Error Code
ANSI standard does not permit records
PLS-01468 – Oracle Error Code
The first argument of the like-predicate must be a column of type character string
PLS-01467 – Oracle Error Code
The value list of the IN predicate- if not a subquery- must contain only value_specifications
PLS-01466 – Oracle Error Code
Null strings are not allowed
PLS-01464 – Oracle Error Code
VARIANCE is not a standard set function
PLS-01463 – Oracle Error Code
STDDEV is not a standard set function
