Oracle Error PLS-01472: In a set_function_specification, if DISTINCT is present, the expression must be a column_specification

Oracle Error Message

PLS-01472: In a set_function_specification, if DISTINCT is present, the expression must be a column_specification

Reason for the Error

In a set_function_specification, if DISTINCT is present, the expression must be a column_specification.

Solution

None