topic Why the oracle view in ArcMap is &quot;0&quot;? in Data Management Questions https://community.esri.com/t5/data-management-questions/why-the-oracle-view-in-arcmap-is-quot-0-quot/m-p/293641#M16854 <HTML><HEAD></HEAD><BODY><SPAN>All the spatial-datas are stored in user "236-gis", non-spatial-datas are stored in user "236-scott". You can see the table1 in table-en.JPG. And I created the view like this:</SPAN><BR /><SPAN>create view peo_count</SPAN><BR /><SPAN>as select column1 as å??å¸?å��, count(column1) as 人æ?°</SPAN><BR /><SPAN>from table1 group by column1;</SPAN><BR /><SPAN>In oracle, the view is like view-en.JPG, but in ArcMap, the view is like arcmap.JPG. All the value is zero. Why?</SPAN><BR /><BR /><SPAN>I used "OLE DB Connection" connected to the "236-scott"(non-spatial-data), and "Spatial Database Connection" to the "236-gis"(spatial-data). </SPAN><BR /><SPAN>Oracle 10.2,ArcSDE 9.3.1,ArcMap 9.3.1</SPAN></BODY></HTML> Wed, 11 Aug 2010 05:57:37 GMT zhujie 2010-08-11T05:57:37Z Why the oracle view in ArcMap is "0"? https://community.esri.com/t5/data-management-questions/why-the-oracle-view-in-arcmap-is-quot-0-quot/m-p/293641#M16854 <HTML><HEAD></HEAD><BODY><SPAN>All the spatial-datas are stored in user "236-gis", non-spatial-datas are stored in user "236-scott". You can see the table1 in table-en.JPG. And I created the view like this:</SPAN><BR /><SPAN>create view peo_count</SPAN><BR /><SPAN>as select column1 as å??å¸?å��, count(column1) as 人æ?°</SPAN><BR /><SPAN>from table1 group by column1;</SPAN><BR /><SPAN>In oracle, the view is like view-en.JPG, but in ArcMap, the view is like arcmap.JPG. All the value is zero. Why?</SPAN><BR /><BR /><SPAN>I used "OLE DB Connection" connected to the "236-scott"(non-spatial-data), and "Spatial Database Connection" to the "236-gis"(spatial-data). </SPAN><BR /><SPAN>Oracle 10.2,ArcSDE 9.3.1,ArcMap 9.3.1</SPAN></BODY></HTML> Wed, 11 Aug 2010 05:57:37 GMT https://community.esri.com/t5/data-management-questions/why-the-oracle-view-in-arcmap-is-quot-0-quot/m-p/293641#M16854 zhujie 2010-08-11T05:57:37Z