By Patch ~ December 14th, 2011. Filed under: Oracle, PL/SQL, Tools.
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 PLVTMR package relies on a couple of other packages, which in turn rely on… Not what I wanted in my current project. I was actually looking for a stand alone package which I could use. So, my search continues and brings me to oracle-developer.net where I found the timer.sql script. It was good, but not good enough.
Continue reading »
| No Comments »
By Patch ~ October 26th, 2011. Filed under: Oracle, Personal.
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 and OPP2009.
| 2 Comments »
By Patch ~ October 14th, 2011. Filed under: Oracle, PL/SQL.
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 exceptions thrown by Oracle.
Continue reading »
| 1 Comment »
By Patch ~ September 14th, 2011. Filed under: Oracle, SQL.
During my work lately I found out some things about SQL (or is it Oracle SQL) that I didn’t know about and have really made my life easier. Well, maybe not easier, but at least it enriched my knowledge 
Continue reading »
| 3 Comments »
By Patch ~ July 24th, 2011. Filed under: Oracle, PL/SQL, SQL, Tools.
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 table in the FROM clause of the query is that you need to use the TABLE() operator to tell the SQL engine that it should treat whatever comes out of the function as if it were a normal table.
Continue reading »
| No Comments »
