ODTUG Kscope12 is just around the corner, yay!
Oh my... I think I am ready :-)
A student asked, “Can you successfully overload MySQL stored procedures, like PL/SQL does in stored packages?” I said: “MySQL doesn’t formally support overloading stored procedures, and doesn’t support packages like Oracle 11g. You can, however, mimic (or fake) overloading with prepared statements. It requires a careful combination of stored procedures, session variables, and the use of a temporary table.”
Sure, Amazon Web Services are generally amazing and wonderful.
Except when they are not.
As you can read here, "parts of Amazon Web Services (AWS) suffered an outage on Thursday which
led to a spread of high-profile sites clocking off the Web for the
evening." Like the PL/SQL Challenge.
And 10 hours later, the PL/SAL Challenge site is still not available.
A question posed by a student: “Why are Oracle Native Dynamic SQL (NDS) USING clause parameters
IN OUT, or
OUT when the
RETURNING INTO clause manages output values?” It a great question, isn’t it? The followup question was also great, “How do you implement an example of NDS
IN OUT parameters?”
After ACE newsletter, the book makes into Oracle Magazine Book Beat section…great feeling and satisfaction that it reaches its readers… Community: Partner News & Book Beat. Filed under: Oracle
In its 11 June 2012 Database Application Developer Newsletter, Oracle writes "The "PL/SQL 101" series, by PL/SQL demigod Steven Feuerstein, is the ultimate quick-start introduction to the language. Even if you are an experienced PL/SQL developer, you may find these articles a handy refresher on language fundamentals."