hk

Right now, I work at one IT Japanesse vendor as an analyst programmer, have been working for almost 3 years. I enjoy making codes, most of them, done in PL/SQL.
Photography is one of my hobby too. Just have my own DSLR recently and trying to explore more lately.

Row to Column (two)

Remember 'Row to Column' function? If you don't want to use function, you can try this SQL script. In this script, I want to gather all employee group by department delimited by comma Here is the script: SELECT deptno, MAX(substr(... more

Previous blog entries:
Feb 11	-	Row to Column (one) function
Feb 11	-	Column To Row function
Oct 12	-	On August 14, 2008

Shangri-La Hotel

Got another free hotel voucher, this time from my office. Still deluxe room in Shangri-La Jakarta hotel. We asked for a kingsize bedroom but they only have twin bed, since the voucher almost expired so we take it.

The room was nice, neat and... more

Previous reviews:
Oct 12	-	Santika Jakarta's Hotel
Henry's favorite reviews:
Apr 28	-	Mangkok Putih