Home » SQL & PL/SQL » SQL & PL/SQL » How to
How to [message #18461] Thu, 31 January 2002 12:36 Go to next message
suman
Messages: 8
Registered: January 2002
Junior Member
if I have a table with code and data as columns.

code data
52 121-568952
52 245-4589
If i query the table for code = 52 i want the query
result as (one record) i.e 121-5689 | 245-4589 .
Please let me know the select statement to achieve this

Report message to a moderator

Re: How to [message #18466 is a reply to message #18461] Thu, 31 January 2002 22:38 Go to previous message
Milind S Deobhankar
Messages: 33
Registered: January 2002
Member
I think you better use PL/SQL for that,develop one function which will append the string using cursor.

Report message to a moderator

Previous Topic: Load new packages into a schema using a database link
Next Topic: How oracle handles the date
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 04 15:00:54 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.