All things Oracle: Generating XML from 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 I show you some SQL functions which are easy to use.  Check it out!

All things Oracle

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:

All very experienced experts that will bring interesting articles!

I will also contribute to this site.
My specialities are SQL, PL/SQL, Forms and Forms Modernization, so expect articles on these topics in the near future on All Things Oracle.

PL/SQL Challenge V2

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 PL/SQL programmers or you want to know/learn more about PL/SQL… Check it out!

PL/SQL Challenge first anniversary

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 than 5800 users from 119 countries… a worldwide success!

But it does not stop with doing a quiz, a lot of questions(and answers) are discussed on the blog.
And those discussions can also lead to something, like an enhancement request for the PL/SQL language  by Bryn Llewellyn(PL/SQL Product Manager at Oracle).

Steven did a great job with the PL/SQL Challenge and it seems like it keeps on rolling: version 2 of the website is coming up with even more challenges for SQL and APEX.

To Steven and his team of reviewers and developers: thanks for the nice quizzes and keep up te great work!
To all players: have fun and good luck!

 

Read from anydata column

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 Continue reading

My quiz on the PL/SQL Challenge

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 the question, the way of asking, the correct words, the answers…
But after a lot of mailing between Steven and the reviewers we finally had a quiz.

A lot people had it wrong, but I hope they don’t mind and are now aware of statement restart.

For more information and discussion about the quiz: PL/SQL Challenge blog

PL/SQL Challenge

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!).

At iAdvise and O2U we have some great PL/SQL developers and to prove that: we are the number one company in the PL/SQL challenge in the last quarter of 2010 and leading in this quarter.
We have three players in the top 100 this quarter of which one is in the top 20.  And this with over a 1000 participants each day.  Not bad I would say.

Not only the experienced players are participating and doing very well, but also our young Apex developers are doing great(one of them was in the beginners top 10 in December).

In the days of  Java, E2.0, SOA, Fusion etc… don’t forget the roots: PL/SQL is still the preferred language on the database!
So, come out and play…and maybe win some prizes at the PL/SQL Challenge.