Home » SQL & PL/SQL » SQL & PL/SQL » concate value in single row (10g winidows)
concate value in single row [message #279125] Wed, 07 November 2007 01:18 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi
select ename,deptno from emp 
where deptno=20

i need the output as
ename                DEPTNO 
SMITH,JHONES,SCOTT    20



Re: concate value in single row [message #279131 is a reply to message #279125] Wed, 07 November 2007 01:28 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Search CONCAT_ALL in this forum
Re: concate value in single row [message #279136 is a reply to message #279125] Wed, 07 November 2007 01:53 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Or Sys_Connect_By_Path ....

Thumbs Up
Rajuvan
Re: concate value in single row [message #279140 is a reply to message #279125] Wed, 07 November 2007 02:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or STRAGG

Regards
Michel
Re: concate value in single row [message #279163 is a reply to message #279140] Wed, 07 November 2007 03:14 Go to previous message
Maaher
Messages: 7062
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: Fri Dec 02 16:26:33 CST 2016

Total time taken to generate the page: 0.20538 seconds