I am adding some data using session manager to layer, and saving them. Those changes are visible in delta table in SDE also. But, when I query to count the base table and versioned view result count, it is same as base table.
I want the base table will give actual count, and versioned view = basetable + delta changes
Using ArcMap 10.6.1, and Oracle as database.
EXEC sde.set_current_version 'version-session-name';
and then your query?