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 […]
Tag: PL/SQL
Result cache is a powerful tool to gain performance in PL/SQL. There are many examples on the internet that proves this, e.g. these articles on All things Oracle: – Result Cache(1) – Result Cache(2) But I’m not going to talk about performance. This article is some kind of warning. First I’ll show you how result […]
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 […]
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 […]
iAdvise blog 