Hi All,
Can you give any idea about the below requirement.
I have the table like below.
CREATE TABLE TESTING1
(
C1 VARCHAR2(50),
C2 VARCHAR2(50),
C3 VARCHAR2(50) ,
C4 VARCHAR2(50)
);
Insert into TESTING1 (C1,C2,C3,C4) values
('EMPNO','ENAME','SAL','DEPTNO');
Insert into TESTING1 (C1,C2,C3,C4) values
('100','BALU','1000','10');
Insert into TESTING1 (C1,C2,C3,C4) values
('200','RAVI','2000','20');
COMMIT;
select *from TESTING1;
Here columns are C1, C2, C3, C4
and
data is like below
EMPNO ENAME SAL DEPTNO
100 BALU 1000 10
200 RAVI 2000 20
we want to show 1st row as columns and from 2nd
row onwards we have to considered data like below
In our project i have 250 columns for above the requirement.
Regards,
Sirish