Categories:

Aggregate Functions (Counting Distinct Values)

BITMAP_BUCKET_NUMBER

Given a numeric value, returns an identifier (“bucket number”) for the bitmap containing the bit that represents the value..

See also:

Using Bitmaps to Compute Distinct Values for Hierarchical Aggregations

Syntax

BITMAP_BUCKET_NUMBER( <numeric_expr> )
Copy

Arguments

numeric_expr

This expression must evaluate to a data type that can be cast to NUMBER.

Returns

The function returns a number that identifies the bitmap containing the bit that represents the value.

Examples

See Using Bitmaps to Compute Distinct Values for Hierarchical Aggregations.