34.7 POINT Function

This function creates a point at (p_lon, p_lat).

Syntax

APEX_SPATIAL.POINT (
    p_lon        IN NUMBER,
    p_lat        IN NUMBER,
    p_srid       IN t_srid DEFAULT c_wgs_84 )
RETURN mdsys.sdo_geometry;
    

Parameters

Table 34-7 POINT parameters

Parameter	Description
p_lon	Longitude position.
p_lat	Latitude position.
p_srid	Reference system (default c_wgs_84).

Returns

Table 34-8 POINT Function Returns

Return	Description
mdsys.sdo_geometry	The geometry for the point.

Example

This example is a query that returns a point at (10, 50).

select apex_spatial.point(10, 50) from dual;

This example is equivalent to:

select mdsys.sdo_geometry(2001, 4326, sdo_point_type(10, 50, null), null, null) from dual;