Home » RDBMS Server » Server Utilities » concatenating the values
concatenating the values [message #71468] Wed, 06 November 2002 09:37 Go to next message
uma
Messages: 67
Registered: May 2001
Member
I want to concatenate all the values in a column. Like all the TEXT in ALL_VIEWS for a VIEW_NAME. I don't remember how but I saw a sql before.

Thanks
Uma

Report message to a moderator

Re: concatenating the values [message #71504 is a reply to message #71468] Fri, 15 November 2002 03:23 Go to previous message
gp
Messages: 46
Registered: September 2002
Member
select column1||column2||column3||column4 from table

or u can also use concat function...
hope this helps

Report message to a moderator

Previous Topic: recursive sql statements
Next Topic: pretty urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 23 11:44:42 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.