view counter

PL/SQL Feed

Oracle PL/SQL (Procedural Language/Structured Query Language) resources, news, and support articles.

April SQL Quizzes at the PL/SQL Challenge by AMIS

I am very pleased to announce that the SQL quizzes at the PL/SQL Challenge for the month of April are provided by Lucas Jellema and Patrick Barel of AMIS (you will find at the end of this post a description of AMIS). Patrick is a longtime player at the PL/SQL Challenge, and also both reviews and authors SQL quizzes. Lucas is Chief Technology Officer of AMIS and a well-known and highly-regarded presenter at numerous Oracle conferences.

It's AMIS Month for the SQL Quiz!

I am very pleased to announce that the SQL quizzes for the month of April are provided by Lucas Jellema and Patrick Barel of AMIS (you will find at the end of this post a description of AMIS). Patrick is a longtime player at the PL/SQL Challenge, and also both reviews and authors SQL quizzes. Lucas is Chief Technology Officer of AMIS and a well-known and highly-regarded presenter at numerous Oracle conferences.

I hope that you enjoy their SQL quizzes. My deepest thanks to AMIS for supporting the Oracle community through the PL/SQL Challenge site.

Dutch preview event 'Collaborate 12'

'COLLABORATE 12: Technology and Applications Forum for the Oracle Community’ is de grootste Oracle gebruikersgroep conferentie ter wereld en wordt jaarlijks georganiseerd in de Verenigde Staten.

A Hierarchy of One? (11633)

The 28 March quiz on object type hierarchies asked players to identify those keywords that "that are needed to create an object type hierarchy". Several players wrote to object to the way the quiz was scored:

Ah, Those Edge Cases! (11632)

The 27 March quiz tested your knowledge of collections, and the kinds of assumptions you might make when writing a program that accepts a collection as a parameter.

Good Deeds - It's All Relative

A "news analysis" piece in the Sunday New York Times, titled "Text to Driver: That’s My Space," that explores a growing phenomenon of "parking rage." That's when you sit in your car in your parking spot and do some texting or emailing or twittering or facebooking or....anything that involves having your head bent over a small smartphone device and moving your thumbs, rather than driving away and letting someone else use the parking spot.

MySQL REGEXP Error

While working through prepared statements in MySQL, there was an interesting regular expression question raised. A student wanted to know how to address the following error message:

ORA-03113 and Bulk Collect

It can be quite frustrating when you are working on a database package and your session is terminated time and time again and leaves you clueless as too why this is happening. First of all, this is reproducible on an Oracle 10g Enterprise Edition - haven't tried other versions (yet).


SQL> @../utils/rel

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production

Two Years of the PL/SQL Challenge, and Looking Ahead

The second anniversary of the PL/SQL Challenge's launch date (8 April) approaches. Two years of daily quizzes, and so much more. Excellent time to reflect on how things have gone and how they can be improved in the future.

Ohio and New York High Performance PL/SQL Trainings

I will be doing one day trainings on high performance PL/SQL and Oracle Database 11g new features in Columbus and Manhattan (NY) in April:

April 16 - Columbus more info
April 18 - Manhattan more info

These are one day, whirlwind explorations of the many ways you can get those PL/SQL programs running faster, including:

view counter