view counter

PL/SQL Feed

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

Oracle 12c PL/SQL Published

Oracle Database 12c PL./SQL ProgrammingAfter writing nine books, it’s always great when the author copies arrive. That’s when I know the process is complete.

Oracle 12c PL/SQL

While you try to eliminate all errors when you write a book, some exceptions remain and some new opportunities present themselves. I think we did a great job on this book and the errors are minimal, but readers bring new insights and rereading what you’ve written brings fresh ideas. This errata includes corrections of mistakes, suggestions for change, and improvements to the base text. If the book is successful, I’m sure they’ll make it into the next edition.

SQL Quiz: How does this table disappear?

An SQL magic trick – the table disappeared, just by running a select statement! Can you figure out how it’s done?
select *
from
the_disappearing_table_trick
/

NOW_YOU_SEE_ME
--------------
Now you don't

--....

select *
from
the_disappearing_table_trick
/

ORA-00942: table or view does not exist
If you think you know, put your answers in the comments!

Favorite stories: how programmers benefited from my book(s)

I received this very pleasant note today from a PL/SQL developer:

Finding All the Red M&Ms: A Story of Indexes and Full-Table Scans

In the database design quiz on the PL/SQL Challenge, a player made a comment referring to a 5% rule for indexes – i.e. that an index will (only) be used when accessing 5% or less of the rows in a table. This is something I’ve heard others refer to as well, so I thought I’d put together a post explaining how indexes work via the medium of chocolate!

SQL Brainteasers: Guess the Disease

I’ve not been too well recently, so to “celebrate” here’s six SQL clues to various diseases. Can you get them all? Put your answers in the comments!

Participants in the Q4 2013 PL/SQL Championship

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

Congratulations to all listed below on their accomplishment and best of luck in the upcoming competition!

We
currently plan to hold the championship on 27 February (all at the same time world-wide), and are waiting for confirmation from players that this day will work.

Participants in First-Ever Annual SQL Championship

The following players will be invited to participate in the first-ever SQL 2013 championship.

As you can see, we have "tweaked" the rules for championships as follows: the top 50 ranked players are now eligible to compete!

See the FAQ for an explanation of the three ways a player can qualify for the championship.

We currently plan to hold this championship on 12 February. 

And congratulations to all listed below on their accomplishment and best of luck in the upcoming competition!

Participants in First-Ever Annual Logic Championship

The following players will be invited to participate in the first-ever PL/SQL Challenge Logic 2013 championship.

As you can see, we have "tweaked" the rules for championships as follows: the top 50 ranked players are now eligible to compete!

We currently plan to hold the championship on 19 February.

See the FAQ for an explanation of the three ways a player can qualify for the championship.

And congratulations to all listed below on their accomplishment and best of luck in the upcoming competition!

The Database Design Quiz in Numbers: Player Feedback Stats

I’ve done more analysis of the first quarter of the Database Design quiz on the PL/SQL Challenge. This time I’ve had a look at the quiz survey results to see what did and didn’t like, whether or not the quizzes are too hard and what people want to see more or less of.
Here’s the figures:

view counter