Bar Solutions WebLog

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 [...]

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).

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 [...]

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 [...]

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 [...]