Is there a way to get "ordered" resultset from oracle table without actually using an "ORDER BY" clause?
I am working on an application that reads data from oracle table (which has no unique column) and I want to introduce some sort of resume mechanism so that in case of query failure (e.g. network error during fetch) we avoid reading rows that are fetched already.
The application is developed using oracle OCI and currently simple select queries are used.
Is there any efficient mechanism to achieve this?