Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to bring records in one row?

userP5Oct 5 2006 — edited Oct 9 2006
I have output from my query as :
EMP_ID     EMP_HOME_TEL_NO    EMP_OFFICE_TEL_NO    EMP_CELL_NO
12                         345
12                                                 4567
12                                                                                                 66767
34                         67
34                                                                                         90

I want this as
EMP_ID EMP_HOME_TEL_NO EMP_OFFICE_TEL_NO EMP_CELL_NO
12                   345                   4567                             66767
34                   67                                                           90

due to security constraint of my employer I can not put my query here. But can anyone tell me how to achive this using lag or lead functions or by any other method. Thankx in advance. The quick reply is appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2006
Added on Oct 5 2006
33 comments
1,244 views