ST_Curve

メモメモ:

ST_Geometry in Oracle only

Definition

ST_Curve constructs a curve feature from a well-known text representation.

Syntax

sde.st_curve (wkt clob, srid integer)

Return type

ST_LineString

Example

This example creates a table with a curve geometry, inserts values into it, then selects one feature.

CREATE TABLE curve_test (id integer, geometry sde.st_curve);

INSERT INTO CURVE_TEST VALUES (
1910,
sde.st_curve ('linestring (33 2, 34 3, 35 6)', 0)
); 

SELECT id, sde.st_astext (geometry) CURVE
FROM CURVE_TEST;

ID     CURVE

1110   LINESTRING (33.00000000 2.00000000, 34.00000000 3.00000000,
              35.00000000 6.00000000)
 

3/6/2012