Hello,
I have created one layer for offline editing ex. EXISTINGQUARRY, added 2 features to the layer (EXISTINGQUARRY) from ArcMap. When I open the attribute table I can see 2 records (screenshot1)
When I see the table from SQLDeveloper with following command – select * from EXISTINGQUARRY,
around 10 rows are seen in the table. (Screenshot2)
I want to know why this is happening, because when I create a query layer I am getting many repeated records for the 2 features.
Noticed that a View is created in Oracle with name EXISTINGQUARRY_EVW if I query this I can see only 2 records as it is seen through attribute table in ArcMap. Want to know why is this happening, is this the expected behaviour or am I doing some mistake?
Softwares used:
ArcGIS Desktop 10.2.2
ArcGIS Server 10.2.2
Oracle 11.2.0.1