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 moreReport in APEX
The other day someone at a customer had a question about displaying a report. The different options are in a table so he could easily use a report to display the options. But he wanted to display three columns of options. That is, if there are 10 options, he would want to display 3 rows […]
Read moreCodeGen and APEX.
When building code to support your APEX application, it is always nice to be able to generate large parts of that code. I am really fond of creating code using the QDA. The only trouble is that you need to create all the packages separately. What I have found works for me is to create […]
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 moreExport APEX to the rescue…
I had a good time in Atlanta at OPP doing my presentations. When I got back I had some issues regarding our APEX application that I needed to solve. But the guys at the office decided to drop all objects from the schema and create all the necessary objects again. This way we got rid […]
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 more