SELECT
deptno,
RTRIM(xmlagg (xmlelement (e, ename || ',')).extract ('//text()'), ',') enames
FROM emp
GROUP BY deptno;
Your's
Amar Alam
The main idea is to help the Oracle Technical community and one point store most of the technical solutions. If you have good content that you think can be posted that is not present in this blog, shoot a email to oraclebyamar@gmail.com
SELECT
deptno,
RTRIM(xmlagg (xmlelement (e, ename || ',')).extract ('//text()'), ',') enames
FROM emp
GROUP BY deptno;
Your's
Amar Alam
3 comments:
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.
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.
oracle fusion hcm online training
Post a Comment