35.46 SDO_UTIL.H3_IS_VALID_CELL

Format

SDO_UTIL.H3_IS_VALID_CELL(
  h3_key IN RAW
) RETURN BOOLEAN;

Description

Returns TRUE if the given H3 key is correctly formed and identifies an H3 cell; otherwise, the procedure returns FALSE.

Parameters

h3_key

The H3 key to be validated.

Usage Notes

None.

Examples

The following example queries use the SDO_UTIL.H3_IS_VALID_CELL procedure to determine the validity of the input H3 key:

SELECT SDO_UTIL.H3_IS_VALID_CELL('0877AA5145FFFFFF') FROM DUAL;

SDO_UTIL.H3
-----------
TRUE

SELECT SDO_UTIL.H3_IS_VALID_CELL('0000000000000000') FROM DUAL;

SDO_UTIL.H3
-----------
FALSE