在oracle数据库中存储经度和纬度的数据类型 [英] Data type for storing latitude and longitude in oracle database
问题描述
纬度:48.858844300000001,
经度:2.2943506,
CREATE TABLE cola_markets(mkt_id NUMBER PRIMARY KEY,name VARCHAR2(32) ,形状SDO_GEOMETRY);
和 $ b
CREATE TYPE sdo_point_type AS OBJECT (X NUMBER,Y NUMBER,Z NUMBER);创建类型sdo_elem_info_array AS VARRAY(1048576)的NUMBER; CREATE TYPE sdo_ordinate_array AS VARRAY(1048576)NUMBER;
要插入和选择查询,请阅读Oracle文档 here
I want to store latitude and longitude in oracle db. Which data type its good to use it for both these fields. I really appreciate for your reply.
"latitude": 48.858844300000001,
"longitude": 2.2943506,
CREATE TABLE cola_markets ( mkt_id NUMBER PRIMARY KEY, name VARCHAR2(32), shape SDO_GEOMETRY);
And for point
CREATE TYPE sdo_point_type AS OBJECT ( X NUMBER, Y NUMBER, Z NUMBER); CREATE TYPE sdo_elem_info_array AS VARRAY (1048576) of NUMBER; CREATE TYPE sdo_ordinate_array AS VARRAY (1048576) of NUMBER;
For inserting and select queries please read Oracle document here
这篇关于在oracle数据库中存储经度和纬度的数据类型的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!