Archive for January, 2007

Adding custom functions to Excel

Sunday, January 28th, 2007

If you are, like me, programming in different languages, maybe you have also noticed that you miss certain functions in a language, which are available in a different language.
What I am used to do, is either find a function or functions that perform the same task:
Delphi: Dec(i);PL/SQL: i := i - 1;

or create a function [...]

Oracle SQL Developer also for MySQL

Sunday, January 21st, 2007

This post on Download Squad pointed me to trying Oracle SQL Developer to connect to my MySQL database on this website. After unpacking the download, I tried to connect but apparently I needed some extra software to connect to MySQL.
This link on the Oracle site shows the following table. It appears that the needed jar files are [...]

Switched to FireFox…

Sunday, January 14th, 2007

 I finally made the switch from Maxthon (for tabbed browsing) to Firefox. I needed a couple of extensions, like the mouse gestures extensions, but I think I got all the functionality I liked in Maxthon embedded in FireFox now.
 After installing FireFox, I decided to take a look at ThunderBird, since my current email application, Eudora, [...]

Tabs in output

Sunday, January 7th, 2007

By default, when you press the tab-key in the editor, the indent is replaced by spaces. I wanted the generated code to contain tabs instead of spaces, so I have created the following code: An Oracle Stored Function:
create or replace function tab_char return varchar2 is begin   return chr(9); end tab_char;

In the cgml code I have [...]

2007

Monday, January 1st, 2007

Best wishes for the new year. And I hope to create some nice blog entries this year