Wednesday 27 April 2022

How to display column values in a row in oracle?

 SELECT

   deptno,

   RTRIM(xmlagg (xmlelement (e, ename || ',')).extract ('//text()'), ',') enames

FROM emp

GROUP BY deptno;


Your's

Amar Alam

3 comments:

Emblixacademy said...

Emblix Academy –Digital Marketing Institute in KPHB, we address all major and minor aspects required for any student’s advancement in digital marketing. Clutch USA named our Digital Marketing Institute the best SEO firm. The future of digital marketing is promising and full of possibilities.
As a result, skilled digital marketers who can keep up with the rising demand are in high order.
In the Emblix Academy Digital Marketing Institute in KPHB, you will learn about all the major and minor modules of digital marketing, from Search engine marketing to Social Media Marketing and almost all Tools used for Digital Marketing.
One stop place for all Digital Marketing courses! Emblix Academy is a Team of dedicated Professionals with 12years of experience in various Digital Platforms. We assure to provide the best Digital Marketing courses to enhance your Career.

TOM said...

Oracle is so difficult as I use it it in my daily office work. I never understood it. But by your guidance. I understood that how I can display column values in a row in oracle. Now it's time to avail Taxi Wolverhampton for more information.

4 said...

oracle fusion hcm online training

Post a Comment