In celebration of my trip to Vegas last week, here’s clues to card games in SQL form:
select surname || first_name
where films in (
'Kung Fu Panda',
select (select name
where atomic_number = 79) ||
(em / 2)
select replace(name, chr(107), chr(116))
The following SQL statements are all clues to the names of trees:
set state = 'burnt';
where type = 'second person';
where nationality = 'Dutch';
set appearance = 'smarter';
from elements e
join punishments p
where e.atomic_number = 47
and p. (more...)
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:
where topic = 'Database design';
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:
Here’s another six SQL brainteasers. This time the SQL is a clue to the power(s) of a superhero. Who is each superhero?
insert into body (skeleton)
set strength = 'superhuman'
where emotion = 'anger';
delete from powers
where location = 'near Kryptonite';
set exoskeleton = 'ferrous material';
where equipment = 'noosed rope of veracity';
insert into boy (more...)
There’s a problem most people who’ve had to do production datafixes have encountered at some point: you need to update a dataset. Unfortunately there’s a trigger on the target table. The trigger either prevents the update outright or just has some unwanted side effects (firing off a business process, etc.). The trigger is necessary for the application to function correctly, so you can’t just drop it.
How do you apply the changes?
You can (more...)
Some more SQL clues, this time to chocolate bars.
where capital_city = 'Taipei'
and 9 = roman;
where position = 4;
where age = 'prepubescent';
where crew = 'mutinous';
where that_is = 'Eboracum';
When you’ve got them, put your answers in the comments!
set employer = 'Oracle',
job_title = 'Database Evangelist'
where name = 'Chris Saxon';
That’s right, as of last week I’m now an Oracle employee! I’m joining Steven Feuerstein’s database evangelist team, a hugely exciting opportunity I’m honoured to be a part of. I’ll be joining Natalka, Dan and Todd in helping people customers get the most out of their Oracle databases.
My focus will be SQL and Oracle’s differentiating features (more...)
Another batch of SQL brainteasers. This time the clues are to the powers of mythical creatures – the task is to guess the creature!
There’s six in all, can you get them all? Put your answers in the comments!
set state = 'stone';
delete from creature
where appendage = 'head';
insert into creature (appendage)
insert into creature (appendage)
Continuing the nation theme, here’s another six SQL clues to countries. Can you get them all?
where business = 'abbreviated';
where contents in ('beef', 'kidney beans');
where actor = 'Tom Green';
where allegiance = 'Confederate';
where second_person = 'female';
As always, put your answers (more...)