53.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 53-7 POINT parameters
Parameter | Description |
---|---|
|
Longitude position. |
|
Latitude position. |
|
Reference system (default c_wgs_84). |
Returns
Table 53-8 POINT Function Returns
Return | Description |
---|---|
|
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;
Parent topic: APEX_SPATIAL