view counter

PL/SQL Feed

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

Oracle Within Group

Somebody asked me for a useful example of Oracle 11gR2′s new analytical LISTAGG function that uses a WITHIN GROUP syntax. They’d noticed an update to the askTom that showed how to use it. This post shows how to list values without a displayed aggregation column and how to use a JOIN and GROUP BY clause with the new analytical feature.

Final beta test for PL/SQL Challenge 2.2

Dear players,

I invite (no, rather, I implore) you to visit beta.plsqlchallenge.com and help us do a final round of testing for release 2.2 of the PL/SQL Challenge website. We've added many new features that will help you get more out of our growing repository of quizzes and resources.

Q1 2011 Ends, Time for Next Playoff

Friends,

Q1 2011 ended on Friday, as far as the daily quizzes are concerned. Which means it is time to prepare for the championship playoff for that quarter. And a congratulations to the hundreds of players who committed a substantial amount of time playing quizzes, learning about PL/SQL, SQL and APEX, and in many cases sharing their knowledge with others through our discussion.

An Exclusive Thank You from Packt Publishing — Any 3 Packt Ebooks for just $19.99

Good Morning and Happy April month to all, Here is a great offer from Packt publishers for the week. Don’t wait !! Hurry This week only and to thank you for your custom in the past we have two exclusive offers for you: Buy three Packt ebooks for just $19.99.

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.

view counter