view counter


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

Recursive Foot-in-Mouth Syndrome

The Republican primary contest has offered many examples of the well-known Foot-in-Mouth Syndrome, whereby candidates say things that cause them, at a minimum, some embarrassment and, even worse for them, lost votes.

Today while reading the Chicago Tribune, I discovered a rare variation of the syndrome, Recursive Foot-in-Mouth Syndrome (RFIM), in which a candidate, while explaining why his foot was planted firmly in his mouth, plants a foot within that foot.

Methodical Performance Tuning Part 2 by Arup Nanda: AIOUG webcast

Arup Nanda delivers yet again a useful webcast on Oracle performance tuning practices. This time he shows the utilization of V$ views to analyse the session level waits and statistics. Download links are as below Besides, the reviewing activities on “Book in Making” are going smooth.

Over 450,000 Answers to 681 Quizzes!

Today, the PL/SQL Challenge hit another milestone: players have submitted over 450,000 answers to N quizzes since April 2010.

 We just passed a big milestone at the PL/SQL Challenge: over 450,000 answers have been submitted for the over 680 quizzes offered since its inception in April 2010. Here are some stats:

The Insanity of Stock Trading in the 21st Century

As anyone who's read my blog or otherwise knows me is aware, I have more than my share of criticisms of capitalism. I am not sure it is possible to come up with a better economic system than one that is market-driven. I am very certain, however, that our political system - whose sole purpose should be to protect and improve the quality of life of its citizens - must put boundaries around the behavior of capitalists.

In other words, the political system must taken priority over the economic system.

New Qualifier Process for Playoffs

We will be instituting a new process for the upcoming Q1 2012 championship playoff.

All or some of the players who qualify to participate in the playoff will be required to take three qualifier quizzes.

If the performance on these qualifier quizzes is substantially worse than the player's performance during the quarter (% correct and/or time required to answer the quiz), then the following steps will be taken:

1. That player will be ineligible to participate in the playoff.
2. That player's status will be set to non-competitive.

Fedora URL Changes

Somebody posted on a Gnome patching blog post for Fedora to let me know that the download URL was invalid. I poked around and it appears that the old Fedora URL at Red Hat’s site doesn’t work:

You now have to go the Fedora Project web site for the code archive, and it’s here:

If somebody knows why they made the change without any fanfare, please post a note.

Upgrading to Oracle 11gR2, presented by Syed Jaffar Hussain

Oracle ACE Director Syed Jaffer Hussain presents a webinar on upgrading database systems to Oracle 11gR2.

Implicit and Explicit dependencies

Shadows of the Truth by Alexandre Borovik offers an interesting perspective upon human learning experience. The book is abundant with examples of concepts being challenging at the early age, but clarified later (sometimes, much later) in life. One of my stumbling blocks was the definition of implicit and explicit dependencies. Now, with modest help of relational thinking (that is, basic dependency theory) I can report some progress.

My iPhone is back …

Life’s interesting, and thankfully AT&T is no longer the sole provider of the iPhone. On December 21st, 2010, I replaced my iPhone 3G with a LG Optimus S using Sprint. It was adequate, and far cheaper than what AT&T was charging me. It also had 3G service because AT&T didn’t provide coverage in Rexburg, Idaho.

How to use object types?

A tale of Oracle SQL object types, their constructors, and how you use them. This demonstrates what you can and can’t do and gives brief explanations about why.

The following creates a base SAMPLE_OBJECT data type and a sample_table
collection of the base SAMPLE_OBJECT data type.

view counter