Oracle Virtualization and Cloud Consulting
view counter

PL/SQL Feed

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

Three Out of Four Isn't Too Bad

We held two annual championships last week (SQL and Database Design).

We held a third this week on Logic.

They all went pretty smoothly.

In 2.5 hours it is time for the grand finale: the PL/SQL Championship.

And the PL/SQL Challenge website just went down. Possibly another DDOS attack.

I suppose I should feel proud that our website is so high profile, so mission critical, that someone thinks it is worth their time to attack it.

i-Blason Prime

I replaced my OtterBox Defender with an i-Blazon Prime case when upgrading to the iPhone 6. It appeared a good option, and for 4 months it was fine. Yesterday, the latch broke and my iPhone fell to the ground as a walked.

The Database Design Quiz in Numbers: 2014 Review

The results of the first ever database design championship playoff were announced today. Huge congratulations to Sean Molloy, Pavel Zeman and Justin Cave for taking the top three spots. Also thanks to everyone else who’s taken part in the quiz, answering questions, adding to the discusions and pointing out my mistakes ;)
With this in mind here’s a some of the facts and figures from 2014’s database design quizzes, along with related trivia:

Results of First-ever Database Design Annual Championship

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

Congratulations first and foremost to our top-ranked players:

1st Place: Sean Molloy of United States

2nd Place: Pavel Zeman of Czech Republic

10 Cool things about the COMPARE_SYNC package

@thatjeffsmith recently recommended an article about making your blog more popular. The article said "lists of 10 things" were great ways to get more readers. Hey, if that's all it takes...

COMPARE_SYNC is a package that generates SQL to compare data or synchronize tables.

Results of Annual SQL Championship for 2014

You will find below the rankings for the 2014 SQL Championship; the number next to the player's name is the number of times that player has participated in a championship.

Congratulations first and foremost to our top-ranked players:

1st Place: Andrey Zaytsev of Russia

2nd Place: Pavel Zeman of Czech Republic

SQL Server XQuery

I promised my students an example of writing xquery statements in Microsoft SQL Server. This post builds on two earlier posts. The first qualifies how to build a marvel table with source data, and the second qualifies how you can create an XML Schema Collection and insert relational data into an XML structure.

You can query a sequence with xquery as follows:

Insert into XML Column

Working through Chapter 7 of the Querying Microsoft SQL Server 2012 book for Microsoft’s Exam 70-461, I found the XML examples incomplete for my students. I decided to put together a post on how to create:

SQL Brainteasers: Guess the Superhero

Here’s another six SQL brainteasers. This time the SQL is a clue to the power(s) of a superhero. Who is each superhero?

view counter