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:

Computing the Number of Distinct Values for Hierarchical Aggregations

Syntax

BITMAP_BUCKET_NUMBER( <numeric_expr> )

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.