The 4 July quiz tested your knowledge of the impact of querying more than one row with a SELECT INTO. The TOO_MANY_ROWS exception is raised, but the question then is: what if anything will the variable(s) in the INTO clause of the SELECT statement be set to?
As we state in the answer:
The SQL quiz on GROUPING SETS (week of 25 June) raised the following objection from a player:
We are pleased, indeed, to present to you the 44 players who have qualified to participate in the Q2 2011 PL/SQL Championship Playoff. For more details on how these players are selected, check out the FAQ. It takes lots of discipline and knowledge to make it to the playoffs, and we congratulate every single one of you.
We currently plan to hold the playoff on Thursday, 21 July, though that could change if enough players cannot participate on that day.
That's a great line (from Abraham Lincoln's Gettysburg address) and I daresay that many Americans instinctively believe in it....but I also would betcha that very few Americans believe it is true.
I can still remember the night that Ronald Reagan beat Jimmy Carter. We sat around in shock. How could this clown have won?
And then the latest cycle of the onslaught by the rich and powerful against...everyone else...started again in this country. Reagan and his cohorts followed an astonishingly simple formula:
With the advent of a wide array of new quizzes (SQL, APEX, Logic - and more to come!), you will also naturally want to see rankings for those quizzes.
Today, you can view rankings for these other technologies as follows:
First, on the home page in myPerformance, simply choose a different technology from the dropdown list and you will see the playing stats for that technology.
Congratulations to all players for another busy, interesting quarter of quizzes and conversation at the PL/SQL Challenge.
As you've noticed, there was a lot of change at the website this past quarter, most importantly:
But through it all, over 2,600 Oracle technologists continued to take the daily quiz (not all of you every day, of course!). Such dedication!
The 29 June quiz asked you to figure out the text that would be displayed on the screen when this block was executed:
BEGIN DBMS_OUTPUT.put_line ('-3,2='||SUBSTR ('abdefg', -3, 2)); DBMS_OUTPUT.put_line ('-7,2='||SUBSTR ('abdefg', -7, 2)); END; /
A number of players were unhappy with this quiz. Here are some of the comments:
Of course you know that Oracle has released 11g Express Edition, still in Beta though. That is probably why I ran into something weird -must be a bug- while playing with it. Here is what I did:
SQL> set echo on
SQL> col "Current_Edition" format a20
SQL> col object_name format a20
SQL> select sys_context('userenv'
3 ) "Current_Edition"
4 from dual
Eight months ago, you could visit www.plsqlchallenge.com and play the daily PL/SQL quiz...and that was it. If you wanted to play the monthly Toadworld PL/SQL quiz, you had to go to a different URL. It was a very limiting and inflexible.
I visited the home page of www.plsqlchallenge.com today and was overjoyed to see this:
Starting next week (starting, in other words, tomorrow!), the PL/SQL Challenge will offer a third weekly quiz (in addition to SQL and APEX), this time with a focus on deductive logic.
Deductive logic lies at the heart of all programming endeavors. Without logic and reason, we would not have, well, just about anything you associate with "civilization" - and certainly there would be no programming. The better you are at deductive logic, the better you will be at writing software.