topic Re: Manage spatial data using PL-SQL in Developers Questions

Manage spatial data using PL-SQL

testtest7 — Fri, 02 Sep 2016 07:14:38 GMT

How can I copy a feature from a feature class table to another? I can not see the feature when I use select insert statement.

Re: Manage spatial data using PL-SQL

JoshuaBixby — Sat, 03 Sep 2016 14:25:57 GMT

https://community.esri.com/groups/geodatabase?sr=search&searchId=9fd68534-c9ea-475a-bd2f-64d052ab0b10&searchIndex=0‌, https://community.esri.com/community/gis/managing-data?sr=search&searchId=4c05d2fa-0e63-41ca-9c24-c166e8b5065b&searchIndex=0‌

Re: Manage spatial data using PL-SQL

JoshuaBixby — Sat, 03 Sep 2016 14:27:47 GMT

You haven't given us much to go on. For starters, it would help to see your SQL or some representative SQL. Also, some basic information about the database, or is it a geodatabase?

Re: Manage spatial data using PL-SQL

testtest7 — Fri, 09 Sep 2016 02:58:41 GMT

I have a feature class , its shape type is numeric(38). I would like to copy feature from one feature class to another using SQl

insert into FeatureA(a,shape) select (a,shape) from FeatureB;

But only shape field will null after use the SQL

Re: Manage spatial data using PL-SQL

JoshuaBixby — Fri, 09 Sep 2016 16:13:42 GMT

What backend DBMS are you using?

Re: Manage spatial data using PL-SQL

testtest7 — Mon, 12 Sep 2016 06:54:57 GMT

oracle 10G