I think this would make a reasonable question for would-be database developers:
[Full Article]
Wednesday, March 17, 2010
Subscribe to:
Post Comments (Atom)
I've moved...
About Me
- Jeffrey Kemp
- I'm a computer programmer and I like quiche. I'm a pianist and I occasionally tolerate fast food. I've been working with Oracle (SQL, PL/SQL, Forms, Designer) since 2000 (version 7.3.4, Forms 4.5), since then with versions 8.1.6, 9i and 10g, and Developer 6i, 9i and 10g. My favourite edible substance is Iced Coffee.
I sense a background story to this... :-)
ReplyDeleteI was trying to think of a good background story to this, but I'm just not that creative :)
ReplyDeleteIt's just something that popped into my head - I was typing the "ALTER TABLE" today, and thought, "I bet this would confuse someone who didn't know the difference between DML and DDL".
So, I'm a bit boring today.
Today's story - there was I pontificating about array fetch / bulk collect etc etc ... when someone asks:
ReplyDelete"Excuse me, what's that SQL extension you are using at the bottom of the SQL. I've never seen it..."
..... (long pause by me....)
"Um...That would be the GROUP BY clause"
Hmmmmm.........
:)
ReplyDeleteThat's another good interview question: "Explain the difference between ORDER BY and GROUP BY."
For advanced developers: "Is an ORDER BY required if a statement to be sorted already has a GROUP BY? Why?"
On a totally separate note....Jeff you need to update your movie list in your profile! It reads 'Geek'. ;-) Being a fellow iced-coffee lover I would hate for folks to associate the two together!
ReplyDeleteHello Anonymous!
ReplyDeleteI haven't checked my profile for ages - but not much has changed, really. Anyway, if I can convert just one iced-coffee-afficionado into a geek, or vice-versa, I will consider my mission to be complete :)
Hi Jeff. This is Anonymous. Good answer! But at least throw a Clint Eastwood movie in there. ;-) Ok Ok I'd settle for 'My Cousin Vinny'!
ReplyDelete