SDO_UTIL.H3_STRING_TO_INT

Format

SDO_UTIL.H3_STRING_TO_INT(
  h3_key IN RAW
) RETURN NUMBER;

Description

Converts the RAW hexadecimal representation of an H3 index to its numeric 64-bit integer representation.

Parameters

h3_key

This parameter represents the hexadecimal value of an H3 key in RAW format.

Usage Notes

The returned value is the numeric representation of the H3 index.

Use SDO_UTIL.H3_INT_TO_STRING to convert the value back to its hexadecimal representation.

Examples

The following example converts an H3 index from its hexadecimal representation to its numeric representation:

SELECT SDO_UTIL.H3_STRING_TO_INT('89283087033FFFF') FROM DUAL;
617700171168612351