Home » SQL & PL/SQL » SQL & PL/SQL » How to
How to [message #18461] Thu, 31 January 2002 12:36 Go to next message
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
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
I think you better use PL/SQL for that,develop one function which will append the string using cursor.
Previous Topic: Load new packages into a schema using a database link
Next Topic: How oracle handles the date
Goto Forum:

Current Time: Fri Sep 22 04:11:51 CDT 2023