I needed some help in knowing whether we can have an option of sorting the rows of the table in Oracle based on the time of insertion.
Like do we use any sorting of function based indexes.
I would like to perform this operation of auto sorting without having to declare any new column for recording time.
Does the oracle server keep track of that information which i can use for sorting.
Thanks in advance
Jeffrey Kemp :
Oracle doesn't record the \"time of insertion\" for you, so you must add that column yourself, set it to the current time (e.g. SYSTIMESTAMP) on every insert, then ORDER BY that column when you query the table.",
2014-03-26T04:27:50