Hello guys, Recently I have been asked by Packt to review their book “Oracle Database XE 11gR2 Jump Start Guide” authored by Oracle ACE Asif Momen. I am glad to have my copy in my account. I have gone through the book contents and it looks like a structured stairs for beginners in Oracle database … Continue reading »
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.