In het midden van de 90-er jaren waren er heel weinig en vrij beperkte ontwikkeltools beschikbaar voor het ontwikkelen van PL/SQL. Tegenwoordig is dat heel anders en zijn er verschillende leveranciers van IDE’s voor het ontwikkelen van en beheren van databaseobjecten en databasecode. Toad for Oracle van Quest en SQL Developer van Oracle zelf zijn […]
Read moreCategory Archives: PL/SQL
Testing Rulegen using Codetester
When I was confronted with the possibilities of Rulegen it made me wonder: How can these rules be tested. I have some experience using CodeTester but as the name says, it’s a code tester where rulegen builds rules in the database that can actually only be tested using SQL statements (insert, update, delete).
Read moreTriggers…
I ran into an issue at a customer site where certain triggers were disabled in the database where they should be enabled. It appeared that an update script, that is run every night, first disables all triggers on a couple of tables. Then does what it needs to do, without the overhead of the trigger […]
Read moreWriting code…
I am writing lots of code again. Building a package that imports different files into the database. I thought I should share a bit of my working experience with you. As you may (or may not) know, I am a big fan of Allround Automations PL/SQL Developer, so that’s my main tool for this job. […]
Read moreMy SOA architecture and webservices mindset…
At AMIS they are working on teaching a lot of us about the fundamentals of SOA. We just had the first couple of events in which Lucas and Peter taught us stuff about XML and BPEL. To get an idea of what SOA and webservices actually are and how we should work with them.
Read moreBlogging block…
I seem to be suffering from a blogging block (like a writers block, but for a blogger). Maybe it’s my new job at AMIS or the new application at the KPN I am working on. It’s a lot of figuring out what is going on. Reading through other peoples code and try to understand their […]
Read moreOracle 11G – Virtual Columns (Dates)
A couple of days ago there was a question (in Dutch) on the utPLSQL forum about filling up a table with a lot of dates and some info about those dates, like the weeknumber, the dayname etc. I created code using persistent columns at first, so the code would run on a pre-11G installation, but I was […]
Read moreOracle 11G – Virtual Columns
As written before, I am currently trying out some things on Oracle 11G after a presentation by Lucas and Alex of Amis. One of the new features they talked about was the virtual columns option in Oracle. This a column based on an expression that doesn’t really exist in the database.
Read moreSpeed or Readability…
I have been thinking about an issue of speed versus readability lately. Which one prevails over the other. I have a case statement and a loop which positions can be interchanged to come to the same result.
Read moreOracle 11G – Follows in Trigger
I’ve seen a presentation on the 11G new features from Alex and Lucas at Amis. One of the questions posed there was when you are using the new follows option in triggers, what would happen if you have two triggers following the same one. A bit like the way it”s done right now.
Read more