So I was asked to beta test the new student plsql ...something... training program, for new student programmers to learn the basics of the tools we use here at WOU. I was created by students for students! (Catchy, right?)
So it looks pretty good, easy to use and goes over the basics. I really am nit-picking, but I wanted to get all the bugs down:
In the try it boxes, there are spaces in the textarea that have to be deleted before typing will work. Otherwise it just shows it as wrong.
In GET/POST - submit button doesn't show t
In JAVASCRIPT - "Click to Execute" doesn't do anything..
What should go there? <script> or rescomp.js ?
In the try it, a new window pops open, but the Home link on that page takes you out of the portal with no style.
On all continue to next section, I always get the alert: You are not allowed to view this page yet.
PL/SQL - It says to delete everything, but don't delete author, created date, and purpose! It's important for later programmers to know a little about this program later.
Also, I noticed the use of htp.prn(', htp.p(' and htp.print(' without explanation.
In the URL for the db, also give the aliases - public2db and debug2db.
INFINITE LOOPS - Add exit or exit-when for them to test it, ie EXIT WHEN x > 5;
EXCEPTIONS - weather should be whether
PL/SQL Quiz - This quiz was ridiculous. It took me 6 times to pass it, and that was just by remembering what I picked before and using a process of elimination. The answers are confusing and there are gotchas, which is not the point of quizzes. Some are even plain wrong:
What's done every time you create a table? -> Says correct answer is create test data, but that is not what the training said. It stated to create a sequence.
Foreign Key is suppose to be a key from another country? Come on...
Doesn't keep money total from quiz to quiz.
Doesn't give correct answer when wrong.
Question make a custom exception -> should be declare a custom exception.
exception BOO; -> should be BOO exception;
when BOO then...
SEQUENCES - misspell --> relationps
RELATIONSHIPS - They primary key --> The primary key
ODL and SSN Example - intelligible (?) I think you mean something else; subscript 1 on hover says Easter Egg! I'm not sure what's up with that.
Okay, that's all I got for now.
