Many times ask me my students when we have – at least – two solutions for a particular problem, which is the best queries ?
The correct answer is typically complex, and started “ It depends on ….” or “let’s see the environment…”.
Let’s see the following simple example:
We would like to select those employees whose salaries are greater than their department’s average salary!
1. First solution can be:
Wow, I’ve been busy since OOW2011. This is the first post since I left for San Francisco. My Android phone got blown out by a forced upgrade and would only charge when actively connected across the USB to the computer. At the conference, my laptop was sidelined as a charger.
In the 2008 election campaign, Obama was the #1 recipient of contributions from Wall Street firms and individuals. Employees of Goldman Sachs, alone, contributed $1 million. I don't know about you, but when I heard of this, I was very worried. Is he really going to stand up to the very companies who paved his way to victory? Did he make a "back room" deal to let these robber barons and their underlings avoid prosecution and come out financially whole?
The 13 October quiz tested your knowledge of the DBMS_ERRLOG package and what happens when you try to create an error logging table for a table that has unsupported column types, such as CLOB.
Several players wrote with objections along this line:
My friend told me at Oracle Open World in San Francisco how much he likes his new smartphone; he uses it for so many things, the interface is really nice....he is so pleased with it.
And I found myself thinking in response: I like not having a relationship with my phone.
I have a relationship with my laptop, and it's not particularly healthy.
So I am quite content to have my phone be a smallish, squarish lump in my pocket until someone calls or I need to call someone.
James Su, a PL/SQL Challenge player, recently asked for permission to translate quizzes and post them on a site for Oracle developers working in the Chinese language.
I was, of course, delighted to give him this permission.
You can now check out his work at: