OraFAQ Forum: SQL & PL/SQL » concate value in single row

Home » SQL & PL/SQL » SQL & PL/SQL » concate value in single row (10g winidows)

Wed, 07 November 2007 01:18

oracle_coorgi
Messages: 188
Registered: September 2006
Location: INDIA-karnataka

Senior Member

select ename,deptno from emp 
where deptno=20

i need the output as

ename                DEPTNO 
SMITH,JHONES,SCOTT    20

Wed, 07 November 2007 01:28

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Search CONCAT_ALL in this forum

Wed, 07 November 2007 01:53

rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India

Senior Member

Or Sys_Connect_By_Path ....

Thumbs Up

Rajuvan

Wed, 07 November 2007 02:03

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Or STRAGG

Regards
Michel

Wed, 07 November 2007 03:14

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Or MODEL clause Very Happy

MHE

Previous Topic:	Can we call Sql Loader in PL/SQL
Next Topic:	storing log of sql statements

Goto Forum:

]

Current Time: Thu Apr 18 18:13:18 CDT 2024