Oracle Virtualization and Cloud Consulting
view counter

PL/SQL Feed

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

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:

INSERT ALL master/detail data from XML

This is something I actually made for a quiz on PL/SQL Challenge, but I think the technique could be useful for others as well :-)

view counter