AMIS proud sponsor of the SQL Challenge

SQL today is the foundation for any successful application. Whether it is a SOA implementation, an ADF or APEX application, a Forms application or any other usage of the Oracle Database (or any other relational database), SQL is key for the success. AMIS has embraced the evolution of SQL through the subsequent releases of the […]

Read more

ACED and KScope12

For a couple of days my Twitter timeline is filled up (well, it’s not all that is happening) with the news that Oracle will cancel it’s support for a lot of conferences. One of them being the KScope12 conference. This is to bad, although, considering the current economic status, I can somehow understand why Oracle […]

Read more

Timing in PL/SQL

In my current project I wanted to add some timing to the logging the code already does. So I started my search for a good timing package. My first idea was to download PL/Vision and use the timer that is in there. Installing this was not as simple as I hoped it to be. The […]

Read more

Oracle ACE

Just a quick note to let the world know of the fact that I am now officially an Oracle ACE. I am even in the Ace Directory. Thanks to Learco Brizzi of Itium Oracle Professionals for nominating me. And thanks to AMIS for making it possible for me to present at different conferences like KScope11 […]

Read more

Make use of exceptions

While I was browsing the supportforum of PL/SQL Developer by Allround Automations I came across a thread about the special copy function of PL/SQL Developer. In this thread a function was written to determine if a sent in parameter (VARCHAR2) was numeric or not. I took this implementation and created my own depending on the […]

Read more

Using Table Functions

Overview of table functions Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be queried like a physical database table. You use a table function like the name of a database table, in the FROM clause of a query. The difference with a physical database […]

Read more