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!

display column values to a single row

user4199159Oct 8 2013 — edited Oct 9 2013

Hi.. ,

My requirememnt is using oracle sql or plsql  to fetch the 'ORIG_SYSTEM' from hz_orig_sys_references table based on the ownere_table_id paramenter passed to it . There may be multiple 'ORIG_SYSTEM' for one owner_table_id but i want to display all 'ORIG_SYSTEM' of each owner_table_id in a single row sepreted by '_' .Please suggest any effective solution for this .

Desired Output .

'ORIG_SYSTEM'  OWNER_TABLE_ID

AXIS-QUT-OBI     1056

ZST-FBS-TIU       2309

Orignial Data

ORIG_SYSTEM'  OWNER_TABLE_ID

AXIS                      1056

QUT                       1056

OBI                         1056
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2013
Added on Oct 8 2013
10 comments
2,105 views