BITMAP_BUCKET_NUMBER to construct a one-to-one mapping between a number and a bit position in a bitmap.
expr is of type
NUMBER. It represents the absolute bit position in the bitmap.
BITMAP_BUCKET_NUMBER returns a
NUMBER. It represents the relative bit position.
expr is NULL, the function returns NULL.
expr is not an integer, you will see the following error message:
Invalid value has been passed to a BITMAP COUNT DISTINCT related operator.