35.57 SDO_UTIL.H3SUM_LIST_TABLES

Format

SDO_UTIL.H3SUM_LIST_TABLES(
  all_h3sum   BOOLEAN DEFAULT FALSE
)RETURN H3SUM_LIST_T PIPELINED;

Description

Returns a listing of H3 summary tables as a table of type MDSYS.SDO_UTIL.H3SUM_LIST_T.

Parameters

all_h3sum

List of H3 summary tables.

By default, only tables in the current user schema are returned. If this flag is TRUE, then visible tables in all schemas are returned.

Usage Notes

H3 summary tables are identified by the H3SUM-specific index created on them.

This function returns a table of type MDSYS.SDO_UTIL.H3SUM_LIST_T, which is defined as follows:

TYPE MDSYS.SDO_UTIL.H3SUM_LIST_ROW_T IS RECORD
(
  tsname          VARCHAR2(130),
  sdo_table_name  VARCHAR2(130)
);
TYPE MDSYS.SDO_UTIL.H3SUM_LIST_T IS TABLE OF H3SUM_LIST_ROW_T;

Examples

The following example lists all the H3SUM tables in user A schema (AGG1_H3 and X180_H3) only.

SQL> select * from SDO_UTIL.H3SUM_LIST_TABLES();
TSNAME    SDO_TABLE_NAME
------ ----------------------
  A           AGG1_H3
  A           X180_H3

In the following example, the all_h3sum flag is set to TRUE. Therefore, the example lists the H3SUM tables both in user A (AGG1_H3 and X180_H3) and user B schemas (WORLD_H3).

SQL> select * from SDO_UTIL.H3SUM_LIST_TABLES('TRUE');
TSNAME     SDO_TABLE_NAME
------  --------------------
  A            AGG1_H3
  A            X180_H3
  B            WORLD_H3