Valid funny queries
select the join from join join join using(the,some)
select some join from left join join right using(some,the)
select 1 join from join join join join join using(the) on 1=1
select the some from join
where the=some( the(select some from join)
,the(select the from join)
Each June, ODTUG hold its highly respected and enthusiastically attended Kaleidoscope conference. this year it will take place in Seattle. Lots more details here.
And several years ago, ODTUG added a community service day (CSD) on the Saturday before the conference, to give attendees an opportunity to "do good" while they enjoy the perks of a software conference (they are, after all, very perky!).
Yesterday ODTUG announced their CSD for 2014:
Back on the film quizzes this time with a mathematical twist for the clues:
As covered in my new Oracle Database 12c PL/SQL Programming book (publisher’s satisfied), you can evolve object types. That means you can change a base object type and the change cascades through dependents. Somebody asked how to remove an object type chain without appending the
It’s quite easy if you understand writing a recursive function in PL/SQL, as done here:
Just reading about another snake-handling pastor who died from a snake bite.
My feeling about these folks is: go for it. If you want to risk death for your beliefs, why not? It's not like there aren't enough people alive in the world to fill in any gaps you leave behind.
As some of you may recall, we held our first non-PLSQL and non-quarterly championship since the PL/SQL Challenge started: the 12 February Annual SQL Championship.
Now, of course, if I had designed my database without any flaws, fully taking into account all possible directions in which the website could go, anticipating all possible user requests, etc., then we would not have encountered any bugs in the process of applying our code base to this new championship.
Ha. Ha. Ha.
That's a question I get a lot.
I guess that's because I am not overweight and kind of tall....?
I can remember a few times when I really enjoyed running: both times they were more an adventure, in which running was the mode of transport. But generally, I have been bored by running so, no, I am not a runner.
In fact, over the past year, I have completely changed my views on exercise, and running is even less a part of what I do to stay healthy than ever before.
Two tables that look the same, but for some reason I can insert my pounds (£) into the first one, but not the second:
As I review with my students, a stored function works like a standalone program, while a stored procedure runs in the scope of another program unit. For example, you can compare the result of a function as an expression in an
IF statement, like: