Home » SQL & PL/SQL » SQL & PL/SQL » how to append the rows
how to append the rows [message #242567] Mon, 04 June 2007 02:38 Go to next message
medepalliramesh
Messages: 2
Registered: February 2007
Junior Member
hi

i have a requirement like to append different rows into single column

for example i have table like xxbc_abcd and the requirement is like this

data is like this

a b c d
- - - -
1 ram 21 hyd
2 mahe 22 hyd
3 shek 23 bang

Now i want like this

b
-
Ram,mahe,shek


can any body tell how to append the rows into a single column.





Re: how to append the rows [message #242569 is a reply to message #242567] Mon, 04 June 2007 02:42 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Your requirement is very difficult to understand. Please read the Sticky at the top of the Newbies forum for instructions on how to format your posts.

Search the forum for CONCAT_ALL for an answer to your question.

Ross Leishman
Re: how to append the rows [message #242572 is a reply to message #242569] Mon, 04 June 2007 02:51 Go to previous messageGo to next message
medepalliramesh
Messages: 2
Registered: February 2007
Junior Member
Hi

this time i hope i will explain you clearly

actually my requirment is like i have column for example party_name in that i have different names , so now i want them in a single row by append them

i think this will help u

Thanks in advance .
Ramesh Medepalli



Re: how to append the rows [message #242579 is a reply to message #242569] Mon, 04 June 2007 03:31 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
rleishman wrote on Mon, 04 June 2007 17:42
Search the forum for CONCAT_ALL for an answer to your question.

Previous Topic: Use of Index by tables
Next Topic: Help need for DBMS_JOB
Goto Forum:
  


Current Time: Fri Dec 09 21:18:00 CST 2016

Total time taken to generate the page: 0.13497 seconds