Friday, June 24, 2011

SQL: Turn multiple rows into one row multiple columns

›
We have a table looks like this: Name Question Value Alan        1           5 Alan        2           4 Alan        3           6 Jim ...
1 comment:
Tuesday, May 24, 2011

Cannot restart LDAP server on Ubuntu

›
I did some changes to the ldif file yesterday, and cannot start my LDAP server any more today. I tried different ways, but all unfortunately...

Intellij IDEA 10.5 stuck in the loading process

›
Intellij IDEA is a really smart IDA that attracts more and more developers to its community. However, a lot of bugs are still hanging there ...
15 comments:
Monday, May 16, 2011

Oracle: To convert a row into a column (CROSS-JOIN)

›
This afternoon, while I am doing some Jasper report stuff, I am puzzled by a SQL query that which takes quite a long time to execute. As the...
15 comments:
Sunday, May 15, 2011

Miscellaneous Points for Oracle Join Query

›
As a software developer, you must have the experience to deal with all sorts of join queries. And I believe everyone has once or still now s...
Monday, April 25, 2011

Australian Permanent Residency and Citizenship

›
Last Friday, after "illegally" struggling in Australia for more than one year, I was granted permanent residency visa. With a lot ...
5 comments:
Wednesday, April 20, 2011

Get rid of JTA warning message for WebLogic

›
This is the second time I ran into the JTA exceptions. Basically, you will get this message every one minute when running your EJB on any ve...
2 comments: