Category: PL/SQL

Did you ever needed your table data in an XML format? Well, it isn’t that hard…  Oracle provides several ways to generate XML, in both SQL and PL/SQL. I wrote an article on All Things Oracle in which I explain step by step how you can generate XML from table data. In this first part […]

There’s a new Oracle source available:  All Things Oracle. The aim of All Things Oracle is to provide a gateway to the wealth of information and material available for Oracle developers and DBAs. The site brings articles and other resources of Oracle experts. Just to name a few: Alex Nuijten -Database Development – Oracle Ace […]

For over a year I play every day the PL/SQL Challenge, as I mentioned already in previous posts. Today there’s version 2 of the website. You can read about it on the PL/SQL Challenge blog. Great effort of Steven Feuerstein and his team! So, if you want to test your PL/SQL knowledge, compete against collegues/other […]

One year ago Steven Feuerstein launched a competition called “The Pl/SQL Challenge“. The idea was to let Oracle PL/SQL developers test their knowledge, learn and win prices by taking a daily quiz. The format seems to be a success: every day more than 1000 PL/SQL developers test their knowledge about the language, in total more […]

What should you do if you have an anydata column in a queue table and you don’t have any tool to read from it(sqldeveloper doesn’t support it natively)? I have written some code to extract all the information from such a column and print it, whatever the content would be. You can find out more

On friday my quiz was on the PL/SQL Challenge. Topic: “Guidelines for Designing Triggers: Avoid Non-Transactional Logic in DML Triggers” Yes, about “statement restart”🙂 My idea about the quiz was “making developers aware of the Oracle behaviour”. And I hope a lot of PL/SQL developers learned from it. It wasn’t easy to come up with […]

Steven Feuerstein started last year the PL/SQL Challenge, a quiz about…PL/SQL! What else could one expect from Steven😉 The PL/SQL Challenge is an interesting quiz to test your PL/SQL knowledge and win some great prizes(up to $1000!). Not only it’s about testing your knowledge, but also about learning a lot PL/SQL(even experienced developers can learn!). […]