Category: 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 will put 5 other new 12c features in the spotlight (in addition to the features of a previous post), that really makes the 12c an improvement against the previous versions of the Oracle database. To get this result I listed up all the major new features and wanted to know my […]

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

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