Multiline In single Line
735688Mar 28 2012 — edited Mar 29 2012Dear All, I am working on ORACLE 10g and i have a record which is stored in multi-lines format. Please share any idea to convert into sing line
Problem:
ID, Name
1 Irfan
Ahmad Lhr
2 Usman
Ahmad Lhr
Expected Solution:
--------------------------
ID, Name
1 irfan ahmad lhr
2 usman ahmad lhr
any idea.
Regards
Irfan ahmad