In the past week (8 August - 12 August), 866 Oracle technologists were busy answering quizzes (over 2,600 answers wee submitted) and exploring the library of past quizzes. Here are the PL/SQL daily quizzes played in that period:
The 11 August quiz explored the concept of "state" in a package and asked you to identify ways to avoid the raising of the ORA-04068 error.
Two players wrote with objections to how the answers were scored. Here are their comments:
Well, it's not the spring any longer, so the massive protests in Israel cannot be called the "Israeli Spring."
Regardless of what you call it, the protests sweeping Israel are inspiring and encouraging, both for what it might mean for the future of Israel and the entire Middle East - and for how it could or should inspire Americans to also "rise up."
Some 300,000 Israelis, overwhelmingly Jewish and secular, protested this past Friday - that is roughly equivalent to some 9,000,000 protesters in the US (by percentage of population). Wow!
Somebody asked how to work around an error message they got after converting one of their who-audit columns to a
TIMESTAMP column. A
TIMESTAMP column has a
ON UPDATE current timestamp. They wanted to have two
TIMESTAMP columns in the same table, with the intention of:
The 9 August quiz tested your knowledge of the restriction (prior to Oracle 11g) that you cannot reference fields of collections of records in a FORALL statement. The FORALL statement we showed in the question is this:
FORALL i IN 1 .. l_tab.COUNT UPDATE plch_employees SET salary = l_tab (i).salary * 1.1 WHERE employee_id = l_tab (i).employee_id;
Notice that the same collection (l_tab) is referenced in both the SET and WHERE clauses.
A player who pays close attention to the Oracle documentation wrote as follows:
Over two years ago I wrote about a way to split a comma delimited string using Regular Expresssions. Just a little while ago someone asked how to split it when you have more records involved than just one (as I used in my example).
Back in 2008, capitalism went belly up. Remember that?
Credit markets froze. Banks failed. Hell, banks couldn't even figure out what assets they actually owned and what they owed to others. The mortgage system completely collapsed. The markets stopped working.
But the United States government (that is, we the people) bailed out the capitalists because, gee, we didn't really seem to have any choice. Nope, no choice, but to hand them hundreds of billions of our hard-earned dollars (and euros and yen and....).
I received this email from a player today:
Aug 04, 2011 2:07pm
The 3 August quiz tested your knowledge of the way that Oracle performs implicit conversions, in particular in this block:
DECLARE n NUMBER; BEGIN n := '123.456' || 900; DBMS_OUTPUT.put_line ('X' || n || 'X'); END; /
We reported the correct answer as:
But several players wrote to say that when they tested our answers with the verification code, they received the following error: