1. SQL Language Reference
  2. Functions
  3. TO_APPROX_COUNT_DISTINCT

TO_APPROX_COUNT_DISTINCT

Syntax

Description of to_approx_count_distinct.eps follows
Description of the illustration to_approx_count_distinct.eps

Purpose

TO_APPROX_COUNT_DISTINCT takes as its input a detail containing information about an approximate distinct value count, and converts it to a NUMBER value.

For detail, specify a detail of type BLOB, which was created by the APPROX_COUNT_DISTINCT_DETAIL function or the APPROX_COUNT_DISTINCT_AGG function.

See Also:

Examples

Refer to TO_APPROX_COUNT_DISTINCT: Examples for examples of using the TO_APPROX_COUNT_DISTINCT function in conjunction with the APPROX_COUNT_DISTINCT_DETAIL and APPROX_COUNT_DISTINCT_AGG functions.