view counter

PL/SQL Feed

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

Where/When Do Players Play?

Throughout November, a poll at the PL/SQL Challenge asked: "We've noticed that, at least for the daily PL/SQL quiz, the bulk of answers are submitted by approximately 16:00 UTC.

More fun with nulls and (bitmap) indexes


Click the image for copy-pastable scripts showing this in action.

Mac Disk Failure & Recovery

The first time I had a major failure on my Mac Pro, I lost a 1 TB Seagate drive and ten key virtual machines. It taught me to apply the principles from my production life to my private life. Swapping the fault-prone Seagate drives for Hitachi drives, I began the slow process of rebuilding those virtual environments.

Upsert method 3: The set based approach


Click the image for copy-pastable scripts to see this in action.

Thank you, UKOUG 2012

So, I'm about to leave UKOUG 2012. I had a good time and learned quite a bit from the smart people gathered in Birmingham ;-)Thank you to those attending my presentation on analytic functions - I hope you learned something from it. If you need to take a closer look, both presentation and scripts can be found here.Birmingham Airport next stop...

Upsert method 2: When you expect to mostly be updating existing data


Click the image for copy-pastable scripts to see this in action.

Upsert method 1: When you expect to be mostly adding data


Click the image for copy-pastable script to see this in action

SELECT-INTO variables

Somebody said, I shouldn’t have buried so much information in an answer to a question posed in a comment on a summary blog page. Especially, since it’s obviously a not real contact information. They suggested I put it in a regular blog post, and here it is with as little editing as possible.

The Ron Quizon user provided this sample code and a “What’s wrong with this PL/SQL program?”

The Oracle equivalent of SHIFT+DELETE


Click the image for example scripts

view counter