User Defined Aggregate Functions in Oracle 9i

February 17, 2009 by Reboot · Leave a Comment 

Just what I needed …

Calculate an Upcoming Birthday in PL/SQL.

February 17, 2009 by Reboot · Leave a Comment 

ADD_MONTHS(s.dateofbirth,CEIL(MONTHS_BETWEEN(sysdate, s.dateofbirth)/12)*12)

Leap-day proof :)

WTF : Magenta Ain’t A Colour

February 17, 2009 by Reboot · Leave a Comment 

Magenta Ain’t A Colour