My org is working on using query layers in ArcMap 10.5.1 for our view-only GIS data where the data originates from an Oracle 12c database that is spatially enabled but not an SDE database. A problem I am encountering with all query layers I have tested, from trivial to more complex, is that sorting is not recognized when you are just viewing the selected records of a query in the attribute table view. Has anyone encountered this type of issue when using query layers whether sourced from Oracle or another type of database (e.g SQL Server, Postgres, etc.)?
Any feedback on this issue is greatly appreciated.