If a column or expression may be NULL, it is a pain to compare it to something else. Why? Because comparisons involving a NULL do not result in TRUE or FALSE: they result in NULL. I use the DECODE function to work around this problem: here's why - and how.
Quite well said – Investment in knowledge is the gives you the best returns. It was a great fun last week to be the speaker at OTN Yathra 2015, organized by All India Oracle Users Group (AIOUG). The OTN tour covered seven cities and I was the part of it at three cities i.e. Hyderabad, Bangalore … Continue reading →
Following the database design championship playoff over on the PL/SQL Challenge, one player asked:
“Could you please advise me some resources (boooks, courses) so that I can improve?”
Of course I can! This is what I love to hear – people looking for resources they can use to increase their skills. This is information I’m sure others will benefit from, so here goes:
We will NOT hold the championship today.
Even if the website becomes available within next two hours, I do not want to take a chance at starting the competition and then having problems before it is done.
We will reschedule for a day and time in March.
Participants will receive an email for a new date and time soon.
But based on requests from the last one, I will put this out idea out now:
What do you think of holding the championship on Saturday?
We held two annual championships last week (SQL and Database Design).
We held a third this week on Logic.
They all went pretty smoothly.
In 2.5 hours it is time for the grand finale: the PL/SQL Championship.
And the PL/SQL Challenge website just went down. Possibly another DDOS attack.
I suppose I should feel proud that our website is so high profile, so mission critical, that someone thinks it is worth their time to attack it.
The results of the first ever database design championship playoff were announced today. Huge congratulations to Sean Molloy, Pavel Zeman and Justin Cave for taking the top three spots. Also thanks to everyone else who’s taken part in the quiz, answering questions, adding to the discusions and pointing out my mistakes ;)
With this in mind here’s a some of the facts and figures from 2014’s database design quizzes, along with related trivia:
You will find below the rankings for the 2014 championship; the number next to the player's name is the number of times that player has participated in a championship.
Congratulations first and foremost to our top-ranked players:
1st Place: Sean Molloy of United States
2nd Place: Pavel Zeman of Czech Republic
@thatjeffsmith recently recommended an article about making your blog more popular. The article said "lists of 10 things" were great ways to get more readers. Hey, if that's all it takes...
COMPARE_SYNC is a package that generates SQL to compare data or synchronize tables.