Oracle Virtualization and Cloud Consulting
view counter


Oracle PL/SQL (Procedural Language/Structured Query Language) resources, news, and support articles.

Friday prank: select from join join join

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)

ODTUG is my favorite Oracle User Group!

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:

SQL Brainteasers: Guess the Film Part 9

Back on the film quizzes this time with a mathematical twist for the clues:

Inlist iterator again

Several months ago I wrote about avoiding inlist iterator, but this post about how to force inlist iterator in queries like that:

Drop Types Recursively

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 FORCE clause.

It’s quite easy if you understand writing a recursive function in PL/SQL, as done here:

Snake handlers and their faith - why not go all the way?

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.

A Glimpse into Feuerstein Refactoring....End Result Better?

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.

"Are you a runner?"

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.

SQL Quiz: What’s different about these two tables?

Two tables that look the same, but for some reason I can insert my pounds (£) into the first one, but not the second:

Signal from a procedure

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:

view counter