Hi,
I have a situation like, I need to group data in rows and display as column, with the grouping row value as the column name.
With the below scenario, you will understand my requirement better,
Below is the EMP table structure with records.
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
| 7369 | SMITH | CLERK | 7902 | 12/17/1980 | 800 | | 20 |
| 7499 | ALLEN | SALESMAN | 7698 | 2/20/1981 | 1600 | 300 | 30 |
| 7521 | WARD | SALESMAN | 7698 | 2/22/1981 | 1250 | 500 | 30 |
| 7566 | JONES | MANAGER | 7839 | 4/2/1981 | 2975 | | 20 |
| 7654 | MARTIN | SALESMAN | 7698 | 9/28/1981 | 1250 | 1400 | 30 |
| 7698 | BLAKE | MANAGER | 7839 | 5/1/1981 | 2850 | | 30 |
| 7782 | CLARK | MANAGER | 7839 | 6/9/1981 | 2450 | | 10 |
| 7788 | SCOTT | ANALYST | 7566 | 12/9/1982 | 3000 | | 20 |
| 7839 | KING | PRESIDENT | | 11/17/1981 | 5000 | | 10 |
| 7844 | TURNER | SALESMAN | 7698 | 9/8/1981 | 1500 | | 30 |
| 7876 | ADAMS | CLERK | 7788 | 1/12/1983 | 1100 | | 20 |
| 7900 | JAMES | CLERK | 7698 | 12/3/1981 | 950 | | 30 |
| 7902 | FORD | ANALYST | 7566 | 12/3/1981 | 3000 | | 20 |
| 7934 | MILLER | CLERK | 7782 | 1/23/1982 | 1300 | | 10 |
I want to display the report as below,
It is like, I wanted to display set of Employees for each department, grouped under their respective jobs.
| DEPTNO | CLERK | PRESIDENT | MANAGER | ANALYST | SALESMAN |
| 10 | MILLER | KING | CLARK | | |
| 20 | SMITH, ADAMS | | JONES | SCOTT, FORD | |
| 30 | JAMES | | BLAKE | | ALLEN, WARD, MARTIN, MARTIN, TURNER |
I have no clue on where to start on this.
The DB version used in our organization is Oracle 10g.
Please help me in this.
Thank you all in adavnce.
Regards,
Shiva