SDO_TOPO_GEOMETRY

Some parts in the output code are omitted for clarity reasons.

Description

This type describes a topology geometry, which is stored in a single row, in a single column of object type SDO_TOPO_GEOMETRY in a user-defined table. (Oracle SQL Language Reference SDO_TOPO_GEOMETRY Data Type).

Definition of SDO_TOPO_GEOMETRY object:

CREATE TYPE SDO_TOPO_GEOMETRY AS OBJECT
  (tg_type        NUMBER, 
   tg_id          NUMBER,
   tg_layer_id    NUMBER,
   topology_id    NUMBER);
/

The SDO_TOPO_GEOMETRY object is not supported in Snowflake.

Sample Source Patterns

SDO_TOPO_GEOMETRY in Create Table

Oracle

Query

IN -> Oracle_01.sql

CREATE TABLE topo_geometry_table(
    topo_geometry_column SDO_TOPO_GEOMETRY
);

Snowflake

Query

OUT -> Oracle_01.sql

CREATE OR REPLACE TABLE topo_geometry_table (
    !!!RESOLVE EWI!!! /*** SSC-EWI-0028 - TYPE NOT SUPPORTED BY SNOWFLAKE ***/!!!
        topo_geometry_column SDO_TOPO_GEOMETRY
    )
    COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
    ;

Inserting data in SDO_TOPO_GEOMETRY Table

Oracle

Query

IN -> Oracle_02.sql

INSERT INTO topo_geometry_table VALUES (SDO_TOPO_GEOMETRY(1,2,3,4));
INSERT INTO topo_geometry_table VALUES (NULL);

Snowflake

Query

OUT -> Oracle_02.sql

INSERT INTO topo_geometry_table
VALUES (SDO_TOPO_GEOMETRY(1,2,3,4) !!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'SDO_TOPO_GEOMETRY' NODE ***/!!!);

INSERT INTO topo_geometry_table
VALUES (NULL);

Known Issues

1. SDO_TOPO_GEOMETRY Data Type not transformed

SDO_TOPO_GEOMETRY Data Type is not being transformed by SnowConvert.

Related EWIs

1. SSC-EWI-0028: Type not supported.
2. SSC-EWI-0073: Pending functional equivalence review.