Tag: SQL

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

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