SELECT
deptno,
RTRIM(xmlagg (xmlelement (e, ename || ',')).extract ('//text()'), ',') enames
FROM emp
GROUP BY deptno;
Your's
Amar Alam
Wednesday, 27 April 2022
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
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
Datos personales
Labels
- AIM (1)
- AOL (29)
- AP (9)
- API's (13)
- AR (9)
- BOM (1)
- D2k (21)
- DBA (6)
- FAQ's (13)
- GL (5)
- HRMS (8)
- India (1)
- Interfaces (9)
- Inventory (9)
- OAF (1)
- OM (28)
- Oracle APPS (71)
- Oracle Cloud (7)
- OTBI and BIP (1)
- Others (2)
- PL/SQL (36)
- PO (14)
- Queries (63)
- SQL (40)
- SQL * Loader (4)
- TCA (8)
- WIP (1)
- WMS (2)
- XML (20)
Total Pageviews
Search This Blog
Powered by Blogger.
Contact Me On Facebook & Linked IN
https://www.facebook.com/amaralam.j
https://in.linkedin.com/in/amarnath-alam-15544632
2 comments:
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