My morning routine for the last few weeks has had a small addition – just a few minutes to log on The PL/SQL Challenge at 8am (WST) and answer a quiz question.
This is a great way to test the depth and breadth of your knowledge of Oracle PL/SQL. Whether you’re a beginner in the field or have years of experience, I’m certain you’ll occasionally learn something new – plus, it’s completely free!
Some of the questions are fairly general, others are trivial; while they’re never “trick” questions, they can still trip you up if you’re not observant!
I think I have an unfair advantage, being in this timezone – early morning is when I am most alert and ready to tackle any challenge.
A couple of things I’ve learned recently:
UTL_FILE.putfcan be used if you want to use C-style “printf” syntax, e.g.
SIGNTYPEis a standard subtype that can only take values of
(I’ve learned a few other things as well, but I’ve forgotten what they were :|)