Lately I’ve been doing lots of production work at the customers site, so there’s not really much that involves new techniques etc. I did however come up with a nice solution to a small problem I faced. Order results by the last character. In normal SQL you can do an Order by to order by […]
Read moreMonthly Archives: July 2007
What’s new???
Well, for one thing, I got a new laptop from the office. This one is great. It’s get an Intel Centrino Dual Core processor (2GHz) and 3.5 Gb of RAM. Wow, that’s about 3.5 times as much as I used to have ;). Downside of getting a new laptop is having to install all the […]
Read moreBy position or by name…
In Oracle PL/SQL you have the possibility to call another program with parameters either by position or by name. Both have their pros and cons I think. Consider the betwnstr function (posted last time) and these calls (all have the same result): l_varchar := betwnstr(‘hello world’ , 3 , 5 , true); l_varchar := betwnstr(‘hello […]
Read moreAutomatic Syntax Highlighting…
In Windows Live Writer you can add Plugins that do certain things for you. One of those things is to add syntax highlighting to your postings. I found a Code Formatter for Windows Live Writer that does just about all you need, except of course for PL/SQL (and Delphi) code. Doing some more searching on […]
Read more