Someone to help me out in selecting the records in a table inserted or updated in the current day?
During the day there are 3 inserts/updates. How can I select these records, right after the insert/update using scn/timestamps?
There is a date column in the table but if I use it the query takes lots of time to finish as I got millions of records in the table…
I appreciate very much some help.
Heitor
