Oracle Virtualization and Cloud Consulting
view counter

PL/SQL Feed

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

MySQL Image Architecture

The MySQL DB Development group posed a questions on how to handle images. Naturally, the argument always goes: Should images be deployed in the database or the file system? I believe they should be stored in the database because the cost and time associated is too high with regard to managing files, a file naming schema, and backing up the file system discretely from the database.

Is Evolution Irrefutable and Compelling?

On my PL/SQL Challenge website, we have a feature called Roundtable, which offers an opportunity to discuss "big picture" questions relevant to Oracle programmers.

The current discussion (well, sharing, really) asks players to share the programming languages with which they work.

In part of my answer, I wrote:

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.

view counter