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

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

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

Action: Specify a value from (0,1(.