News for hackers. Stuff that matters.
Re:Our SQL interview questions by jacques_chester on Tuesday May 28, 2013 @09:23AM (#5779810)
I came to Oracle after it adopted the ANSI syntax, so that's what I use. So my experience is the opposite of yours -- when I see the (+) I need to look up the syntax to remember if it's left or right outer.
Re:Our SQL interview questions by jfb on Tuesday May 28, 2013 @09:29AM (#5779862)
And then I ask, hey, where's my BOOLEAN? And then I drink.
Re:Our SQL interview questions by jacques_chester on Tuesday May 28, 2013 @09:32AM (#5779879)
Oh god.

And the lack of a serial/autoincrement/identity type.

So. Many. Effing. Triggers.

And 32-character identifiers.

sigh

Re:Our SQL interview questions by tmzt on Tuesday May 28, 2013 @07:11PM (#5783477)
It's so much better to use a database that only allows one autoincrementing value per record, or one TIMESTAMP and then only allows you to have either a create timestamp or an update timestamp without writing a trigger.

I prefer the way Oracle does it, you may have to do more work but it's more explicit and flexible that way.

Re:Our SQL interview questions by jacques_chester on Tuesday May 28, 2013 @07:30PM (#5783560)
I don't. I prefer for the common case to be correctly and automatically handled for me.