Categories:

Aggregate Functions (Counting Distinct Values)

BITMAP_BIT_POSITION

Given a numeric value, returns the relative position for the bit that represents that value in a bitmap.

See also:

Computing the Number of Distinct Values for Hierarchical Aggregations

Syntax

BITMAP_BIT_POSITION( <numeric_expr> )

Arguments

<numeric_expr>

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

Returns

The function returns the zero-based position of the bit for that value in a bitmap.