where site_code = 'WC24'
and drive_date between '01-jan-2013' and '31-dec-2013'
If I take min(drive_date) I get 6/5/2013
But I need the next drive_date (6/5/2013). Is there a way in oracle to get the next from the min. The criteria is I want to get drive_date greater than system date I mean 1/17/2013 is past date.
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…