OraFAQ Forum: SQL & PL/SQL » how to append the rows

Home » SQL & PL/SQL » SQL & PL/SQL » how to append the rows

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to append the rows [message #242567]

Mon, 04 June 2007 02:38

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.

Report message to a moderator

Re: how to append the rows [message #242569 is a reply to message #242567]

Mon, 04 June 2007 02:42

rleishman
Messages: 3728
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

Report message to a moderator

Re: how to append the rows [message #242572 is a reply to message #242569]

Mon, 04 June 2007 02:51

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

Report message to a moderator

Re: how to append the rows [message #242579 is a reply to message #242569]

Mon, 04 June 2007 03:31

rleishman
Messages: 3728
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 06 20:19:19 CDT 2024