Oracle VM Consulting
view counter


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

Results from Q2 2012 Championship Playoff

You will find below the rankings for the Q2 2012 playoff; the number next to the
player's name is the number of times that player has participated in a playoff.

Congratulations first and foremost to our top-ranked players:

1st Place: kowido wins US$250 Gift Card .

Going to UKOUG 2012

My presentation on analytic functions has been accepted for UK Oracle User Group Conference 2012 ( #UKOUG2012 ) - awesome \o/Now I just need to tighten up my show and remove all the beginner bits - I've only got 45 minutes for something I could easily use 1½ hour for ;-)See you all in Birmingham in December...

Virtual insensitivity

Click the image for scripts

Happy 80th Birthday, Mom!

Two weeks ago on July 13, an impressive crowd gathered at Benvenuto's in Boynton Beach to celebrate Joan Lee Feuerstein's 80th birthday. My mom was delighted to be surrounded by so many friends and family members, especially all the grandchildren (sadly, her great-granddaughter, Loey, couldn't make it).

Allergy triggers

Click the image for scripts

Seeking Balance

About a year ago, I woke up to find my left shoulder was in flames. Somehow, I had managed to experience a rotator cuff injury in my sleep (likely building upon an injury tenyears ago in a bicycle fall).

It took a whole year for my shoulder to become almost fully functional and pain free. The slowness of the healing was hard for me; I am definitely not healing is quickly as I used to, in general.

Yes, there is no doubt about it: I am getting older with each passing day. I don't like this, but I guess I will have to live with it.

The rules for hinting explained

Click the image for an example script

Top Twelve List

A month ago, I received an email asking for some help on PL/SQL. So I helped. Fahd then replied to me as follows:

"Do you want to know what I like the most about you other then PL/SQL?"

Well, how could I refuse? I wrote back: "Sure, I'd love to know." and so I got the following list:

More fun with nulls

Click the image for a scripted example

Delay or synchronize it?

A couple students in one of my classes ran into a problem when competing Java threads tried to insert new rows in a table. They raised an error when they tried the DELAY keyword to avoid the race (collision) condition in an INSERT statement. It was simple to explain to them that the DELAY keyword doesn’t work with an InnoDB table. Any attempt throws the following error:

view counter