The Lost Dragon

Just browsing through the Delicious bookmarks, I found out this link for Career personality test . Gave it a try and here is what my report was... From the answers you have just provided in the personality questionnaire Deepak Shakya, it's already clear that you need to work in a place where people come first. You work hard at creating harmony because people are important to you. You care how people feel about things. Your job must offer you this Deepak Shakya. It is essential that the company, its managers and its employees value and respect the people that work there. You cannot work in a place that doesn't trully value its people. Not everyone needs this from their work. In fact many people would struggle to understand the importance of it but not you. Well, I personally don't take these kind of opinions, but I guess this is very true from whatever I have experienced in last one year or so.

This is pretty interesting and useful. Sometimes, we might need to aggregate multiple row values into one single column. Oracle 9i provides xmlagg() function to achieve this. Here is the employee table example which aggregates the multiple employee names into one column based on the department no. select deptno, rtrim (xmlagg (xmlelement (e, ename ',')).extract ('//text()'), ',') enames from emp group by deptno ; DEPTNO ENAMES ---------- ---------------------------------------- 10 CLARK,MILLER,KING 20 SMITH,FORD,ADAMS,SCOTT,JONES 30 ALLEN,JAMES,TURNER,BLAKE,MARTIN,WARD Magic isn't it. For more details, refer to the following URL: http://www.dba-oracle.com/t_converting_rows_columns.htm