ST_PointFromText
Nota:
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) );
3/6/2012