Monthly Archives: July 2007

Not much happening…

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 more

By 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 more