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

sde.st_pointfromtext (wkt varchar2, srid integer)

ST_Point

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)
);