Tag Info

New answers tagged

2

Yes, absolutely, you can do that. The principle is to define a function-based index. The steps are like this: Assume I have a table like this: create table customers ( id number primary key, name varchar2(30), longitude number, latitude number ); 1) Define a function that transforms the long and lat columns into a geometry: create or replace ...


1

According to the documentation of the OCI driver (http://www.gdal.org/ogr/drv_oci.html) ogr always creates a column called OGR_FID to be used as row identifier. When appending, the new rows get new values for OGR_FID. That is the behaviour I observe too: - the first load creates the table, including an OGR_FID column. - the subsequent append loads and keeps ...



Top 50 recent answers are included