10 June 2015

PL/SQL Challenge Website Joining Oracle!

When I (re)joined Oracle in March 2014, the PL/SQL Challenge website was also acquired by Oracle. I'd been thinking that in a few months or so, we'd have it up and running on an Oracle server, re-branded with lots of red.

But then, well, I got kind of busy with all sorts of other stuff. My bad.

But I am very happy to announce that over the coming weekend (13-14 June), PL/SQL Challenge will go offline for hopefully no more than a few days and then resurface as an Oracle website.

And that's why for the first time in five years, we will not offer new, competitive quizzes on SQL or PL/SQL or anything else this coming week (we will still put up some of our "deja vu" quizzes). I don't want to set up quizzes and then not give you sufficient time to take them (and you never quite know what's going to happen so....).

Now, those of you who've been to the website know that we use lots of orange (why? Because it's a pleasant color and also is the thematic color of my Oracle PL/SQL books published by O'Reilly Media):

You are probably also very familiar with Oracle's use of red:

Well, do not worry - we are not going to replace all that orange with red. That would make the website unreadable, an assault on the eyes. But come 15 June, our banner will be transformed as follows:

Chills running down my spine....so exciting!

The site will be largely unchanged from current functioning. You will, however, need to accept the Oracle Terms of Use. In addition, since some players may have been using an email address on the PL/SQL Challenge different from their Oracle Single Sign-on email, we will give you an opportunity to synchronize the two accounts:

The "fine print" asks you to authorize us to transfer profile information from the PL/SQL Challenge to your Oracle Profile. We are asking for this, because the PL/SQL Challenge collected all sorts of profile information, some of which is already in your Oracle Profile, which is the "source of truth" at Oracle. So you will no longer be able to provide your name, country or company in the PL/SQL Challenge. Instead this information is stored in your Oracle Profile.

We plan over time to integrate points on the PL/SQL Challenge with OTN community rankings, but that may take a little while to complete. Do not worry, though! All your hard work and dedication on this site will be recognized.

I look forward to a greatly increased level of quiz-taking activity, as well as a broader array of quizzes offered, and I hope you do, too!


  1. Hello Steven,

    I definitely share your excitement and hope that the enthusiasm of our entire PL/SQL Challenge
    community will only flourish further, in the most positive imaginable ways :):)

    I only have a technical question, which sooner or later I was probably going to ask anyway:

    Currently, as long as I am still at work, I do have an official Oracle single sign-on account.

    My question is related to what happens AFTER somebody stops working, so, at a certain stage
    his/her original Oracle Single Sign On account will probably be terminated ?

    1. Is it still possible to own an Oracle Single Sign On account as a "private person",
    who simply wants to continue to develop his/her Oracle skills for purely study purposes,
    including access to new Oracle versions for testing, learning, and so on ?

    2. Will this Oracle Single Sign On account have to be different from the previous one,
    and, if yes, will it be possible "to migrate" the current PL/SQL Challenge account
    ( including the entire activity ) to the new account ?

    3. What are the precise technical steps required to be taken to have "life continuing smoothly" ?

    I hope that I will not be looked at as an "extremely strange animal" for asking such questions :):)
    but I am one of those who do like continuity, like to learn for learning's sake,
    so, maybe and hopefully for other players as well, it would be nice if we had some information
    about how to go on :):)

    Thanks a lot in advance, Cheers & Best Regards,

  2. Iudith, you do not have to have a job to have an Oracle SSO account. You can use whatever email address you'd like.

    We are currently support migration to a non-SSO email address to your (current) SSO account/email.

    We do not have anything in place when a person wants to create a new SSO account with a different email and then "port" their PL/SQL Challenge to this new address.

    I do not know if Oracle more generally offers this capability (for example, you spent 10 years on the forums using your work email address, and then left to join a new company and thus have a new email address (or left a company). I am thinking that profile.oracle.com might let you change your email address, but I am not at this moment sure.

    I AM pretty sure that as an Oracle employee, I cannot change my email address. :-)

  3. Hello Iudith, Steven, all,

    yes it is possible to change your email address for your Oracle account. Just go to profile.oracle.com, log in and then you will see a little textual link "Bearbeiten" (thats German - I think in English it would be just "Edit") to change your email address.

    Kind regards, Niels