29.4 SDO_PC_PKG.CLIP_PC_INTO_TABLE

Format

SDO_PC_PKG.CLIP_PC_INTO_TABLE(
  pc_table                VARCHAR2,
  pc_column               VARCHAR2,
  id_column               VARCHAR2,
  id                      VARCHAR2,
  query                   MDSYS.SDO_GEOMETRY,
  where_clause            VARCHAR2,
  result_table_name       VARCHAR2,
  lods                    MDSYS.SDO_LODS_TYPE,
  category_table          VARCHAR2 DEFAULT NULL,
  category_match          VARCHAR2 DEFAULT NULL,
  category_query          VARCHAR2 DEFAULT NULL,
  include_unblocked_table NUMBER DEFAULT 0
) PARALLEL_ENABLE;

Description

Queries point clouds of any model and stores the result in a table.

Parameters

pc_table

Name of the table where the SDO_PC object is stored.

pc_column

Name of the column where the SDO_PC object is stored.

id_column

Name of the ID column in the pc_table.

id

ID value of the ID column identifying the SDO_PC object.

query

SDO_GEOMETRY representing the geometric query.

where_clause

Not currently used.

result_table_name

Name of the output table that stores the results.

This table is automatically created.

lods

List of level of details (LODs) for point clouds with pyramiding enabled.

This is an optional parameter.

category_table

Not currently used.

category_match

Not currently used.

category_query

Not currently used.

include_unblocked_table

Not currently used.

Usage Notes

The SDO_PC_PKG.CLIP_PC_INTO_TABLE function supports all point cloud models, whereas SDO_PC_PKG.CLIP_PC supports only the blocked models. Also, the result is stored in a table, whereas SDO_PC_PKG.CLIP_PC returns a query result without materializing a table.

Examples

The following example queries a point cloud object in table PCS. The PC table column contains the SDO_PC object, and the ID column value is 12345. The example uses a a simple rectangular query window and the results are stored in table QUERY_RESULT_1.

call
  sdo_pc_pkg.clip_pc_into_table(
    pc_table          => 'PCS',
    pc_column         => 'PC',
    id_column         => 'ID',
    id                => '12345',
    query             => mdsys.sdo_geometry(
                           SDO_POLYGON2D,
                           27700,
                           null,
                           mdsys.sdo_elem_info_array(1, 1003, 3),
                           mdsys.sdo_ordinate_array(
                              1,  1,
                             10, 10)),
    where_clause      => null,
    result_table_name => 'QUERY_RESULT_1',
    lods              => sdo_lods_type(1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
  );