Oracle Error ORA-30493: The percentile value should be a number between 0 and 1.

Oracle Error Message

ORA-30493: The percentile value should be a number between 0 and 1.

Reason for the Error

A percentile value for PERCENTILE_CONT or PERCENTILE_DISC function is specified out of range.

Solution

Specify a value from [0,1].