|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/8/2008 10:11:08 AM
Posts: 2,
Visits: 5
|
|
Hi,
I have table which has
input
enc diag
1 66
1 22
1 33
2 11
2 44
2 55
i want the output as
enc diag diag diag
1 66 22 33
2 11 44 55
Can any one help
the above fields are varchar.
thansk in advance please
kunny
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 9/8/2008 7:42:33 AM
Posts: 22,
Visits: 53
|
|
Hi Kunny,
Ya , We can do that ,
try to use CASE & COALESCE Function. This will help you...
Let me know If you are not clear , then I will explain you with the example...
Best Regards,
Maran A
Oracle Certified & DW+BI Proffessional
|
|
|
|