view counter


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

Time for the Q3 2012 Championship Playoff!

The following players will be invited to participate in the Q3 2012 championship playoff. The number in parentheses after their names are the number of playoffs in which they have already participated.

It's very impressive to see the #1 rank taken by a player who has participated in just one previous playoff.  Six players have never been in a playoff before - it's always good to have "new blood" giving those repeat players a run for their money.

Just ignore the problems

Click the image for scripts

Group by Groups

For some time now I have struggled to efficiently "group by groups" on data containing references between our suppliers item numbers and the original equipment manufacturer (OEM) number. I can group those data by supplier and their item number and get a "group of OEM numbers." That group I will call a unique item and I will group the data once more by that group to find which suppliers agree on an item having the same set (group) of OEM numbers.

Unnatural joins

Click the image for scripts

Who cares about the debates? My son won ArtPrize!

Well, he didn't win the "whole" ArtPrize - no one person does. But Chris and his collaborators (known collectively as ABCD 83) won the juried prize in 3-D Art for "More or Less", a most awesome multimedia installation, combining found objects, music and video projection. This photo doesn't do it justice, but you probably won't read the rest of this post without a photo...

Why Stored Programs?

Why should you use stored programs? Great question, here’s my little insight into a situation that I heard about in a large organization.

A very large organization is having a technology argument. In someway, like politics, half-truth drives this type of discussion. This company has hundreds of databases and they’re about half SQL Server and Oracle. The argument (half-truth) states that using T-SQL or PL/SQL yields “spaghetti” code!

Oracle Database 12c, Exadata x3 highlight OpenWorld keynote

Sync up with the Oracle’s keynote at Open world this year Oracle Database 12c, Exadata x3 highlight OpenWorld keynote.   Courtsey: SearchOracle Filed under: Oracle

Uncorrelated subqueries

Click the image for scripts

view counter