ST_PointFromText

Note:

ST_Geometry in Oracle only; for spatial type for PostgreSQL, use ST_Point.

Definition

ST_PointFromText takes a well-known text representation of type point and a spatial reference ID and returns a point.

Syntax

sde.st_pointfromtext (wkt varchar2, srid integer)

Return type

ST_Point

Example

The point_test table is created with the single ST_Point column pt1.

CREATE TABLE point_test (pt1 sde.st_geometry);

The ST_PointFromText function converts the point text coordinates to the point format before the INSERT statement inserts the point into the pt1 column.

INSERT INTO POINT_TEST VALUES (
sde.st_pointfromtext ('point (10.01 20.03)', 0)
);