1. SQL Language Reference
  2. Functions
  3. BITMAP_BUCKET_NUMBER

BITMAP_BUCKET_NUMBER

Syntax


Description of bitmap_bucket_number.eps follows
Description of the illustration bitmap_bucket_number.eps

Purpose

Use BITMAP_BUCKET_NUMBER to construct a one-to-one mapping between a number and a bit position in a bitmap.

The argument 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.

If expr is NULL, the function returns NULL.

If expr is not an integer, you will see the following error message: 

Invalid value has been passed to a BITMAP COUNT DISTINCT related operator.