please, how can I select the oldest records in a table in oracle? and if it is possible to show them by date. Thank you
closed as unclear what you're asking by ypercubeᵀᴹ, Marco, Michael Green, McNets, mustaccio Feb 12 at 15:03
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
Oracle does not, itself, track the date a row is inserted into a table. So unless you yourself design the table with something like a DATE_INSERTED column, and reigorously enforce the proper population of that column, then the answer to "how can I select the oldest records in a table in oracle?" is "you can't".
First Rule of Relational Databases - Rows in a Table have no intrinsic order.
If you want to know when a record was added or updated, then you need to keep track of that for yourself.