Back to Browse

Map In Oracle Apex

205 views
Nov 19, 2024
14:38

Using Map In Oracle Apex • How Using sdo_geometry object read more about sdo_geometry https://docs.oracle.com/database/121/SPATL/sdo_geometry-object-type.htm 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-seconds-to-decimal-degrees • 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) )

Download

0 formats

No download links available.

Map In Oracle Apex | NatokHD