For a project we are currently working on, we needed to generate, and send a Word 2010 document to the client. The document was generated by a great PL/SQL document generation tool called Doxxy, and was sent to the client using the wpg_docload package. This is a standard Oracle pl/sql package that can be used […]

AJAX is becoming important in the world of web applications. APEX has provided us a very easy way to create an AJAX process, by using dynamic actions. Using PL/SQL Actions in Dynamic Actions to communicate with the database without submitting the page will suffice in most cases, but the downside is that the code is […]

In this post, I’d like to introduce 5 of the many new features Oracle 12C brings to us, database developer’s. Of course this blog would be to long to explain them all in detail, so I will stick to a small introduction. Generating a primary key without triggers, using nextval or identity In 12C, you […]

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 […]