I’ve been busy working on other things since APEX 4 shipped. After I got through the installations of Oracle Database 11g XE (see prior posts), figuring out the default user name and password for APEX Administration became a tedious task. The documentation didn’t really help point to what was needed but it’s always in the code.
You reset the APEX Administration Account for Oracle Database 11g XE by doing the following steps:
Here’s the Oracle Database 11g Express Edition step-by-step installation. I did the installation on Window 7 64-bit, and did run into a problem with the Windows Registry on a fresh installation (posted earlier on the blog).
When you download the software from Oracle, you’ll need an account and you’ll need to accept the license agreement.
Finally, I got to install Oracle Database 11g Express Edition (XE) tonight. Unfortunately, I ran into an error during the installation. A quick Google search landed me in the forum, where it gave me the impression it wouldn’t work on Windows 7, 64-bit. However, I’m tenacious with problems like this. Here’s the screenshot for the error:
As explained in a previous blog posting, the Play a Quiz table on the home page has gotten very full and busy. Players have been complaining about not being able to find the quizzes they need to take, or recently took.
So over the weekend we put in place a number of changes that should help you:
1. Moved Play a Quiz to the top of the page
2. Save filter setting as default
3. Quick access to My Technologies
4. Separate tab for Taken/Closed quizzes
While we continue to have problems displaying the plsqlchallenge.com site on IE7, I was particularly dismayed to receive a bug report regarding IE8. A player reported that when he visited the home page, it looked like this:
In the past week (5 September - 9 September), 822 Oracle technologists were busy submitting 2,465 answers to quizzes and exploring the library of past quizzes. Here are the PL/SQL quizzes played in that period:
The 8 August quiz asked you to determine how many conversions Oracle performs for us implicitly when the following block is executed:
DECLARE l_timestamp TIMESTAMP := '2011-08-01'; l_increment PLS_INTEGER := SUBSTR ('10x10=100', 4, '2'); BEGIN DBMS_OUTPUT.put_line ( TO_DATE (l_timestamp) + (l_increment || 0)); END; /
We scored 8 as the correct answer. Two players wrote with the following observations:
The 7 September quiz asked you to compare and contrast the use of SAVE EXCEPTIONS and LOG ERRORS, two mechanisms for continuing past errors raised in DML statements.
Three players wrote with objections, two concerning this choice, which was scored as correct:
Op maandag 19 september zal er bij AMIS een Oracle Open World Preview sessie worden gehouden. Een groot deel van de Nederlanders die het dit jaar gelukt is om aanwezig te zijn als spreker op Oracle Open World zullen hun presentaties geven in Nieuwegein. AMIS-ers Lucas Jellema, Alex Nuijten, Peter Ebell en Aino Andriessen zullen in drie parallel sessies presentaties verzorgen.