Display rows as columns:

SELECT  *
 FROM  (SELECT job,
               sum(decode(deptno,10,sal)) DEPT10,
               sum(decode(deptno,20,sal)) DEPT20,
               sum(decode(deptno,30,sal)) DEPT30,
               sum(decode(deptno,40,sal)) DEPT40
          FROM scott.emp
      GROUP BY job)
ORDER BY 1;

Fmap usage in OBIEE 10g

Create a folder named ' Missing_ ' under OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics folder

copy the images under this folder

ex:copy images.jpg to OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\ Missing_ folder

restart oc4j services.

call the image ex: fmap:\images.jpg

note: it does not support files with JPEG extensions