Answering a question on the OTN forum was a bit tricky to get an analytic sum using a RANGE BETWEEN that would handle leap years, but in the end I came up with a workaround that satisfies the requirement.
Yesterday evening we had the annual "We went to OOW and this is what's new in the world we call Oracle" at AMIS. Starting around 5pm and ending around 10pm a lot of information was presented by several AMIS colleagues.My contribution to the evening was (amongst others) a little bit of new features in SQL and PL/SQL, only a little bit as there is too much to cover in just 20 minutes. It's the little things that make me happy. What is the little thing that I like?When you define a table you can assign a default value to a column (here it comes) based on a sequence.
The following players will be invited to participate in the Q3 2012 championship playoff. The number in parentheses after their names are the number of playoffs in which they have already participated.
It's very impressive to see the #1 rank taken by a player who has participated in just one previous playoff. Six players have never been in a playoff before - it's always good to have "new blood" giving those repeat players a run for their money.