Select to view content in your preferred language

Manage spatial data using PL-SQL

1732
5
09-02-2016 12:14 AM
testtest7
Deactivated User

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
Deactivated User

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
Deactivated User

oracle 10G

0 Kudos