Sometimes when you’re building queries you end up joining tables which you don’t really need (anymore). They are just there to join some other table from which you do need some data. The join is just there to satisfy some foreign key references. It can however greatly impact the speed of your query. If the […]
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 moreBulk Operations in PL/SQL
When I was in Chicago for the OPP2008 and APEXposed event I talked to someone who seems to have trouble understanding bulk operations in PL/SQL. I helped him out by providing a test/demo script, that shows how it could be done. First of all, one of the most important rules of thumb that I got […]
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 moreUnion vs Union All
Do you know the difference between the UNION and the UNION ALL part of a statement? In short, UNION does a sort-unique on both collections. UNION ALL just retrieves all rows, regardless of any double values.
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 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 more