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 moreCategory Archives: Tools
Semaphores (revisited)
In a previous blog I talked about turning triggers on and off using semaphores. I created a semaphore for every table I needed along with its programs to set and unset the semaphore and to get its current state. This was a rather cumbersome process, because for every new trigger I needed to add these […]
Read moreDisplay images with PL/SQL Developer
Alex wrote an entry on displaying images stored as a BLOB in the database here. Since PL/SQL Developer is my (and his) favorite editor, I figured I would do the same he did, but this time using PL/SQL Developer.
Read moreTemplate plug-in…
A while ago I created a plug-in for PL/SQL developer that allowed me to type in a short code, press a magic key and have the short code replaced by the contents of my template. For instance, I type put, press CTRL-J and the code I typed in gets replaced by dbms_output.put_line();. That’s a lot […]
Read moreCode refactoring…
Steven Feuerstein wrote an entry on his Toadworld blog where he checks the refactoring capabilities of SQL-Developer. I am trying the same things in PL/SQL Developer to see if this does do the trick.
Read moreNew PL/SQL Developer plugins
The other day we had a presentation on PL/SQL Developer at AMIS. Theo told a lot about the tool itself and he showed one of my newest plug-ins: Scrapbook. This is a plug in to make sort of a scrap of the current results of the SQL query you just executed.
Read more(Dutch) Woensdag 8 oktober: KC PL/SQL Developer onder de loep (met spreker Theo Tol)
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 moreTesting 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 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 more