SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to shows rows data column wise.

787612Jul 27 2010 — edited Jul 29 2010

Dear All,

I am having following query and output,

select SPL.speciality_description,Emp.FIRSTNAME, DT.FULL_DATE,PD.PATIENTCOUNT,DG.DIAGNOSIS_DESCRIPTION

FROM A_PERFORMANCEDOCTORWISE PD
INNER JOIN D_SPECIALITY SPL ON SPL.SPECIALITYID = PD.SPECIALITYID
INNER JOIN D_EMPLOYEEMASTER EMP ON EMP.EMPID = PD.DOCTORID
INNER JOIN D_DATE DT ON DT.DATE_ID = PD.DATEID
INNER JOIN D_DIAGNOSIS DG ON DG.DIAGNOSISID = PD.DIAGNOSISID

WHERE TO_CHAR(DT.FULL_DATE,'DD/MM/YYYY') = (select TO_CHAR(sysdate,'DD/MM/YYYY') from dual)

group by SPL.speciality_description, Emp.FIRSTNAME,
DT.FULL_DATE, PD.PATIENTCOUNT,DG.DIAGNOSIS_DESCRIPTION

Output:

speciality_description FIRSTNAME FULL_DATE PATIENTCOUNT DIAGNOSIS_DESCRIPTION

REGISTRATION Dr.POOJA 27-JUL-10 12:00 AM 33 Anthrax
REGISTRATION Dr.POOJA 27-JUL-10 12:00 AM 22 Neurocytoma
REGISTRATION Dr.POOJA 27-JUL-10 12:00 AM 55 Balantidiasis
REGISTRATION Dr.POOJA 27-JUL-10 12:00 AM 44 Babesiosis
REGISTRATION Dr.POOJA 27-JUL-10 12:00 AM 66 Black piedra

Now i want output like,

speciality_description FIRSTNAME FULL_DATE Anthrax Neurocytoma Balantidiasis Babesiosis Black piedra
REGISTRATION Dr.POOJA 27-JUL-10 12:00 AM 33 22 55 44 66

Can anybody tell me how to do that ? Please modify the query.

Thanks and Regard's
Harish Patil