If you have ever tried to implement a requirement that implies that either one field is filled, or the other one but not both and not both not then you might have thought about using an XOR function. Unfortunately this is not implemented in Oracle SQL.
Read moreCategory Archives: PL/SQL
Pipelined Table Functions
I have had trouble with a certain view I have to create at the customer site I am currently working at. The view involves 3 SQL queries combined by using a UNION ALL, since the separate queries are mutually exclusive. Using the UNION ALL makes it a bit faster since Oracle doesn’t have to do […]
Read moreOPP Brussels
Coming Wednesday the first edition of the OPP conference in Europe will start. I will be doing a presentation on Thursday on one of my favorite tools: PL/SQL Developer. I will be attending a lot of PL/SQL oriented sessions like ‘The Helsinki Declaration’ by Toon Koppelaars and for instance the ‘SOA for PL/SQL developers’ by […]
Read moreHashing rows…
During my work at the current customer site I was asked to create files with the changes to the data in the database. Normally you would use triggers on the tables to create logs of the records changed. Or use a Flashback Data Archive, which is only available starting Oracle 11G and I am working […]
Read moreOPP 2010
On October 27th and 28th the combined OPP (Oracle PL/SQL Programming) and APEXposed conference is coming to Europe. To Brussels to be exact. I have had the privilege to attend these conferences since the first one in 2005. The nice thing about this conference is that it is the only conference (at least that I […]
Read moreWhere Am I…
On my new job we wanted to provide some logging. Especially about what program is currently running. Of course it would be easy enough to add a line at the start of the program with the name of that program and one at the end. But, as things go during development, names (and types) of […]
Read moreCustom Authentication Scheme In APEX
I have been playing around with Apex 4.0 on http://tryapexnow.com. When playing around with some ideas I have for application I decided to use the logging mechanism I created a while ago, to see what’s going on in the custom code. Since this is a hosted environment it is not too easy to check the […]
Read moreFun with APEX…
During the last couple of days I have been playing around with the new, hosted version of APEX. I know I haven’t been using all the features available in APEX and I have mostly been using my mod_plsql skills, because I don’t know how to do certain things in APEX (yet).
Read moreLife after OPP…
As I am writing this I am on a plane ride back from Atlanta to Amsterdam. I had a great time in Atlanta during OPP. I also enjoyed doing the sessions I presented. One was on ‘Table Functions’ and another was on Collections and Bulk Operations. Both these session were scheduled in the same timeslot […]
Read moreReading values from a varchar2 indexed Associative Array
Oracle has provided us with collections since Oracle 7. It is one of the most renamed features in the Oracle database. In Oracle 7 they were called ‘PL/SQL Tables’. In Oracle 8 they were renamed to ‘Index By Tables’ and since Oracle 9 they are called ‘Associative Arrays’. If you index by an integer value […]
Read more