Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-30482

DISTINCT option not allowed for this function

Cause

The aggregation function did not support the DISTINCT option.


Action

If DISTINCT functionality is desired, rewrite the expression. Apply the DISTINCT clause in a nested SELECT statement to produce the desired values, and then apply the aggregation function in an outer SELECT statement.