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
2 Answers
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.
date
ortimestamp
column?