Map In Oracle Apex

Описание: Using Map In Oracle Apex
• How Using sdo_geometry object
read more about sdo_geometry
https://docs.oracle.com/database/121/SPATL...

for example:
MDSYS.SDO_GEOMETRY (2001,
4326,
MDSYS.SDO_POINT_TYPE (TO_NUMBER ( LONGITUDE), TO_NUMBER ( LATITUDE), NULL),
NULL,
NULL)
• How to Convert Degrees Minutes Seconds to Decimal Degrees
DD = d + (min/60) + (sec/3600)
To read more
https://www.latlong.net/degrees-minutes-se...

• Table Structure Sample
CREATE TABLE PORT_LIST
(
CODE NUMBER,
NAME_A VARCHAR2(200 BYTE),
NAME_E VARCHAR2(200 BYTE),
LATITUDE NUMBER,
LONGITUDE NUMBER,
LOCATION MDSYS.SDO_GEOMETRY,
PORT_TYPE NUMBER(2)
)