posted 23 years ago
Hi,
Is there a way to pull the recent 20 records from Oracle Database table without using any field in particular.
My table contains fields like ,
session_id - looks like random number generator
timestamp with only date not the time.
The table is logged by some application in the background whenever a transaction is occurred.
For example , in any web server if u view the log file thru the administrative screen/console u have this option like display the recent 20 records or display the last first. That kind of thing.
but i don't know how to write SQL query to display the recently inserted 20 records at any point of time.
Thanks and Regards,
mahendran