Manage spatial data using PL-SQL

1459
5
09-02-2016 12:14 AM
testtest7
New Contributor

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.

Tags (2)
0 Kudos
5 Replies
JoshuaBixby
MVP Esteemed Contributor

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?

0 Kudos
testtest7
New Contributor

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

0 Kudos
JoshuaBixby
MVP Esteemed Contributor

What backend DBMS are you using?

0 Kudos
testtest7
New Contributor

oracle 10G

0 Kudos