I was invited by a friend to talk with a group of teenagers about what it's like to be a computer programmer and why they might want to do the same. There were over 50 kids present, ranging in age from 12 to 18. They were great fun: enthusiastic, curious and engaged.
I decided to go light on the actual programming aspect (what code looks like, how you write it) and instead take a fairly big step back/up and talk about some big picture challenges. And to avoid boring these over-entertained kids out of their skulls, we played games - Mastermind and Set. They really enjoyed that.
The next quarterly championship playoff (for Q3 2012) will take place on Wednesday, 24 October. Forty-five players have qualified to take five tough quizzes in forty minutes. Wish them luck!
Here's some background on the players in the upcoming playoff, including the number of playoffs in which they've already played; their rank in that quarter, their rank in the playoff, and their best playoff performance.
My students wanted an example of how to use a lookup table in the database. I thought it would be a great idea to create a simple example like this one.
A lookup table is a generalization that holds lists of values that support end-user selections. The following example uses a combination of the common_lookup_table and common_lookup_column columns to identify sets of value for drop down lists. The end-user selects a value from the list to identify a unique row, and returns a common_lookup_id surrogate key value.
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.