05 May 2012

Update on Q1 2012 Playoff

As some of you may recall, we started a new qualification procedure for this playoff, in which a selected subset of the top-25 ranked players are asked to take three qualifier quizzes to verify their outstanding performance in the previous quarter.

For the Q1 2012 playoff, we asked six players to take the qualifier quizzes.

Much to my surprise and, I must admit, disappointment, all six players have been disqualified: three failed due to simply not taking the qualifiers at all (in fact two of these players stopping taking quizzes in early April - likely after they realized they would have to take qualifiers) and three others did not score well enough to match (or come close to matching) - and thereby validate - their previous performance.

So we have recalculated rankings for Q1 and will now proceed with our new top 25 ranked players and those who are invited to play through the correctness or wildcard selection.

I am, therefore, pleased to announce the following players are invited to compete in the Q1 2012 championship playoff. The number in parentheses after their names are the number of playoffs in which they have already participated. See the FAQ for an explanation of the three ways a player can qualify for the playoff.

Congratulations to all listed below on their accomplishment and best of luck in the upcoming competition. We will schedule the date of the playoff very soon.

Name Rank Qualification Country
Stelios Vlasopoulos (2)1Top 25Belgium
Frank Schrader (6)2Top 25Germany
Jerry Bull (3)3Top 25United States
Zoltan Fulop (0)4Top 25Hungary
mentzel.iudith (5)5Top 25Israel
kowido (4)6Top 25No Country Set
Yuan Tschang (2)7Top 25United States
Syed Ariful Bari (2)8Top 25Bangladesh
Viacheslav Stepanov (4)9Top 25Russia
Siim Kask (5)10Top 25Estonia
Chad Lee (3)11Top 25United States
Kevan Gelling (4)12Top 25Isle of Man
Krzysztof Helbin (0)13Top 25Poland
Vincent Malgrat (1)14Top 25French Republic
Sebastian Kolski (0)15Top 25Poland
Goran Stefanović (0)16Top 25Serbia
Joaquin Gonzalez (4)17Top 25Spain
Niels Hecker (6)18Top 25Germany
Dieter Kowalski (0)19Top 25Germany
_tiki_4_ (1)20Top 25Germany
Marco Siefert (0)21Top 25Germany
Michal Cvan (4)22Top 25Slovakia
Vladimir Drozdov (0)23Top 25Russia
Mike Pargeter (5)24Top 25United Kingdom
Ivan Blanarik (0)25Top 25Slovakia
Jack Callaham (1)26CorrectnessUnited States
Sean Stuber (3)27CorrectnessUnited States
Justin Cave (4)28WildcardUnited States
Ninoslav Čerkez (2)30WildcardCroatia
Thierry Poels (2)32CorrectnessBelgium
norton (0)33CorrectnessUnited States
Randy Gettman (5)35CorrectnessUnited States
Alexander Polivany (3)37WildcardUkraine
Anna Onishchuk (4)38WildcardIreland
Tobias Stark (0)40WildcardGermany
Jeff Kemp (7)54WildcardAustralia
Vebjørn Koksvik (0)58WildcardNorway
haennesche (0)76WildcardGermany
Nick Cook (0)78WildcardNo Country Set
Gideon Bruggink (1)80CorrectnessNetherlands
sbramhe (3)91CorrectnessNo Country Set
Rimantas Adomauskas (0)104CorrectnessLithuania
Alain Boulianne (2)174WildcardFrench Republic
Elena Rakhimov (0)175CorrectnessCanada
Sanjuinfo (0)328CorrectnessNo Country Set

WYSIWIG HTML Editing in Version 2.2 of PL/SQL Challenge

Many players have had the pleasure of submitting a quiz and then seeing it played by hundreds of developers aroudn the world. If you have not yet done so, I encourage you to give it a try.

Other players review quizzes to help us make sure they are free of errors and as interesting as can be.

All of these people provide content that usually benefits from HTML tags, especially showing code in a fixed font format.

When we upgraded to 2.2, we started using the native CKEditor for our "rich text fields". This has caused some confusion, because the toolbar of HTML tools that was previously always visible is now hidden initially. This is good because it takes up less room on the page. It's bad because players might not be able to find it. Hence, this post.

So if you are typing into a field and would like to do some HTML formatting, look for the small arrow in the top right corner of the field:

Click on that widget to display the toolbar:
And then if you would like to change the font for code, click on Normal and change to Formatted:
I hope that helps with your editing.

A Discussion Forum on the PL/SQL Challenge?

A player submitted this request yesterday:

"Hello Steven, I just wonder that are you planning to open forum in pl/sql challenge? Because I really would like to discuss and talk about quizzes. I think the only shortage in this site is forum. There should be a forum for users in order to discuss and talk about quizzes. Please do something for this. Thanks for your help."

While we have no plans to implement a "typical" forum on the PL/SQL Challenge, such as you would find on OTN or many other places, with our recent upgrade to version 2.2, you can now do precisely what this player desires.

Each quiz has a Commentary section, as you can see in the sidebar on the left side of the Quiz Details page (drill down from Library or home page):

There are three different kinds of comments/discussions you can have on a quiz.

Ask for Help - you are trying to use the feature that is the focus of this quiz and could you use some help.

Raise Objection - you think there is a problem with the quiz as it is currently presented, and think it should be changed - or the scoring for the quiz should be adjusted.

Start Discussion - general discussion about the feature that is the focus of this qui. In other words, you don't think there is a problem with the quiz, but you have some thoughts about or experience with the feature that you want to share with others.


Click on the View Commentary to see all the comment threads published; click on one of the buttons to start a new thread.

We will be going back over the posts to this blog that are specific to a quiz and move the content into the online commentary. This will take some time.

In the meantime, there is nothing stopping any and every player from using this feature to discuss the features tested in the quizzes.

Enjoy!
Steven Feuerstein


21 April 2012

Upgrade to Version 2.2 Complete

We have completed the upgrade of the PL/SQL Challenge to version 2.2. The main features of this release are:

Activity Points

Up through 2.1, the only reflection of your activity on the PL/SQL Challenge was your ranking in the daily PL/SQL quiz, or some other quiz. Of course, the vast majority of players will never find themselves in the top rankings for these quizzes, but they nevertheless spend lots of time and effort at the PL/SQL Challenge improving their skills. In 2.2, we now award points to players for all of their activities on the site (taking quizzes, submitting quizzes, reviewing results, engaging in discussions about quizzes, etc.). Your points total now appears next to your name. Click on the Players menu button to see the points of all players.

Practice Quizzes

Prior to 2.2, you could take a quiz when it is initially offered, and then review results and answers through the Library afterwards. You could not, however, take past quizzes if you'd missed them, no could you re-take a quiz. Now, you can set up practices based on past quizzes, specific features about which you want to learn more, or your favorite authors. You can also use the unique Autotune feature: the PL/SQL Challenge will automatically create practices for you, based on predefined criteria.

Quizbook: Quiz as PDF

One of the most long-sought enhancement requests on the PL/SQL Challenge, the Quizbook feature makes it easy for you to generate a PDF document of one or more quizzes. These can be formatted as an offline test (no answer information included), a player scorecard (showcasing your performance) or a knowledge document, containing all answers and resources. You can save and reuse your Quizbooks; you can also share them with other players.

We are working out a few kinks with the formatting and content of the Quizbook (we have yet, for example, to get Jasper to recognize the pre tags and display code properly), so please do provide feedback on any suggestions you have for improving them.

On-Site Discussions

Rather than discuss interesting aspects of quizzes on the PL/SQL Challenge blog, you can now start or answer a thread directly on the Quiz Details page. You can also ask for help (it must be related to the topic of the quiz) or even post an objection to the quiz. In other words, if you think there is something wrong with the quiz, you can register your concern on both the post-quiz feedback page or on the Quiz Details page. You can also easily see if another player has already submitted a request for a correction.  

Submit Quiz Wizard

 It is now much easier and quicker to submit a quiz. Rather than fill out a long "all or nothing" form - and possibly lose data if there is an interruption, you can now enter a minimum amount of information, save your quiz, and then return later to finish and fine-tune the quiz.  

And Lots More...

We have re-designed and re-organized the Quiz Details page (accessible through Library and other pages) to make it easier to navigate through and access the ever-growing amount of information presented. We've moved the Feedback, FAQ and Blog links from the main menu to hyperlinks in top right corner of the page - to make room for our new features. The Winners page is now under the Players tab on the main menu. Thanks to the many players who beta-tested version 2.2 and identified a number of bugs and ways to improve the application. I am sure that, now that 2.2 is production, you will be telling us about many other ways to make the PL/SQL Challenge more useful and more fun.

Warm regards, Steven Feuerstein

02 April 2012

Final beta test for PL/SQL Challenge 2.2

Dear players,

I invite (no, rather, I implore) you to visit beta.plsqlchallenge.com and help us do a final round of testing for release 2.2 of the PL/SQL Challenge website. We've added many new features that will help you get more out of our growing repository of quizzes and resources.

You can log in using your normal username and password; the beta database contains all quiz results and player data through the end of March. The quizzes you can play, of course, are not the same as those you will find on the production site.

Feel free to give us feedback through the form on the website or in comments to this post.

Many thanks in advance,
Steven Feuerstein

Activity Points

Up through 2.1, the only reflection of your activity on the PL/SQL Challenge was your ranking in the daily PL/SQL quiz, or some other quiz. Of course, the vast majority of players will never find themselves in the top rankings for these quizzes, but they nevertheless spend lots of time and effort at the PL/SQL Challenge improving their skills. In 2.2, we now award points to players for all of their activities on the site (taking quizzes, submitting quizzes, reviewing results, engaging in discussions about quizzes, etc.). Your points total now appears next to your name. Click on the Players menu button to see the points of all players.

Practice Quizzes

Prior to 2.2, you could take a quiz when it is initially offered, and then review results and answers through the Library afterwards. You could not, however, take past quizzes if you'd missed them, no could you re-take a quiz. Now, you can set up practices based on past quizzes, specific features about which you want to learn more, or your favorite authors. You can also use the unique Autotune feature: the PL/SQL Challenge will automatically create practices for you, based on predefined criteria.

Quizbook: Quiz as PDF

One of the most long-sought enhancement requests on the PL/SQL Challenge, the Quizbook feature makes it easy for you to generate a PDF document of one or more quizzes. These can be formatted as an offline test (no answer information included), a player scorecard (showcasing your performance) or a knowledge document, containing all answers and resources. You can save and reuse your Quizbooks, as well as sharing them with other players.

Note 1: we are still finalizing the PDF layout and content, so don't be surprised if something is missing or, well, ugly, but also do not hesitate to tell us what you think needs to be changed. And if, by the way, you have experience with Jasper Reports and would like to help improve our report definition, please let me know.

Note 2: You may have to disable your popup blocker to see the PDF document in your browser; we are working on getting this fixed ASAP.

On-Site Discussions

Rather than discuss interesting aspects of quizzes on the PL/SQL Challenge blog, you can now start or answer a thread directly on the Quiz Details page. You can also ask for help (it must be related to the topic of the quiz) or even post an objection to the quiz. In other words, if you think there is something wrong with the quiz, you can register your concern on both the post-quiz feedback page or on the Quiz Details page. You can also easily see if another player has already submitted a request for a correction.

Submit Quiz Wizard

It is now much easier and quicker to submit a quiz. Rather than fill out a long "all or nothing" form - and possibly lose data if there is an interruption, you can now enter a minimum amount of information, save your quiz, and then return later to finish and fine-tune the quiz.

And Lots More...

We have re-designed and re-organized the Quiz Details page (accessible through Library and other pages) to make it easier to navigate through and access the ever-growing amount of information presented. We've moved the Feedback, FAQ and Blog links from the main menu to hyperlinks in top right corner of the page - to make room for our new features. The Winners page is now under the Players tab on the main menu.

Q1 2011 Ends, Time for Next Playoff

Friends,

Q1 2011 ended on Friday, as far as the daily quizzes are concerned. Which means it is time to prepare for the championship playoff for that quarter. And a congratulations to the hundreds of players who committed a substantial amount of time playing quizzes, learning about PL/SQL, SQL and APEX, and in many cases sharing their knowledge with others through our discussion.

As noted in an earlier post, we are going to change the process for playoff qualification starting with this quarter: some or all of the top-25 ranked players will be required to take special qualifier quizzes to validate their performance in the quarter.

Here's how the qualifier process will work:

1. If you ranked in the top 25 and are not selected to take the qualifier quizzes, then you are in the playoff, with no further action required. Even if you cannot or choose not to participate in the playoff, there is no impact on your rankings or competitive status.

2. If you are selected to play qualifier quizzes, you will receive an email (and a message on the PL/SQL Challenge site) notifying you of the quizzes you must take. They will also, of course, appear on your PL/SQL Challenge home page. You will have three days in which to play the quizzes. If you cannot take the quizzes in that period of time, submit feedback to this effect and we will re-scheduled the quizzes.

3. If you do not want to take the qualifier quizzes, then change your status to non-competitive (visit your Account page, Preferences, and check the box next to "Play for education purposes only?") and notify us of your decision through the Feedback page. If you take this action, any awards you won in the quarter will be reversed.

4. After taking the qualifier quizzes, you will be notified of the results. If you pass, then you have qualified for the playoff and no further action is needed.

If you fail the qualifier, your status will be set to non-competitive and any awards received in Q1 2011 will be reversed. You will remain in non-competitive status for the remainder of this next quarter.

If you previously had your scores adjusted by our "very fast answer" analysis, your account may also be terminated.

For each qualifier failure, rankings will be re-calculated, thereby adding more players to the playoff. Those added to the top 25 may then be asked to take qualifier quizzes (and so the cycle above begins again).

Clearly, this process will delay the date on which the playoff will occur. In addition, the website must be upgraded to 2.2, with its support for qualifiers. We plan to do this upgrade the weekend of 13 April. So during the week of 15 April we will invite some players to take the qualifier quizzes.

Regards,
Steven Feuerstein

31 March 2012

It's AMIS Month for the SQL Quiz!

I am very pleased to announce that the SQL quizzes for the month of April are provided by Lucas Jellema and Patrick Barel of AMIS (you will find at the end of this post a description of AMIS). Patrick is a longtime player at the PL/SQL Challenge, and also both reviews and authors SQL quizzes. Lucas is Chief Technology Officer of AMIS and a well-known and highly-regarded presenter at numerous Oracle conferences.

I hope that you enjoy their SQL quizzes. My deepest thanks to AMIS for supporting the Oracle community through the PL/SQL Challenge site.

Steven Feuerstein

About AMIS

AMIS is an Oracle, Java and SOA Specialist from The Netherlands, founded in 1991. Consistently active as frontrunner with the latest Oracle technology, AMIS is well known around the world for its community contributions, through presentations on conferences, Master Classes, articles in developer magazines, books and its Technology Blog (http://technology.amis.nl). AMIS has 5 Oracle ACEs and ACE Directors among its staff.

AMIS provides consultancy services around Oracle technology, including Database Development (SQL, PL/SQL, APEX); User Interface development using Java/JEE,ADF and WebCenter; SOA & BPM using SOA Suite, BPM Suite and OSB; BI using ODI, OBI EE; Security, Performance, Scalability, Availability and Administration of run time infrastructures including Database, Middleware and VMs. These services are rendered locally in The Netherlands, but also to customers in other countries and continents. Note that the Oracle Database, SQL and PL/SQL have always been crucial in the activities of AMIS.

AMIS is probably best known for its advanced knowledge, experiences and specialists. Knowledge transfer in various forms - training, coaching, reviews, "education permanente" - is a key element of what the company does. AMIS for example can deliver masterclasses and trainings on site (or through webinars) and also offers self-study materials.

The latest initiative from AMIS is the 'further' training program, targeted at experienced Oracle professionals, who are somewhat stuck in traditional tools and technology and perhaps yesterday's versions or ways of working, and who are now ready and eager to 'further' their knowledge and career. This program is offered to individual developers as well as to organizations who have teams to propel in this fashion. The program is provided in various ways and through various channels.

More information about AMIS can be found at the corporate web site, the Twitter account - @AMIS_Services, its technology blog, and through email to info@amis.nl.