hi debasisdas,
putting the code in forum wouldnt be possible for me,
but my query is quite similar to the single matrix query example at the following link
http://download.oracle.com/docs/cd/B14504_01/dl/bi/B10602_01/orbr_matrix.htm
just try the example with salaries figures which do not have any zeros in them.
you may use the folowing insert scripts
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
20, 'Analyst', 5675);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
20, 'Clerk', 56756);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
20, 'Manager', 5676);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
20, 'Salesman', 65756);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
30, 'Manager', 56756);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
30, 'Clerk', 5645);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
20, 'Analyst', 34545);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
10, 'Analyst', 12122);
COMMIT;
thanks,
arr