ArcGIS Server Banner

ST_PointFromText

ST_PointFromText

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

NOTE: Spatial type for 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)
);

See Also

  • An overview of SQL functions used with ST_Geometry types