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!

To display record values as column values

2913583Nov 4 2015 — edited Nov 6 2015

Hi,

I have a requirement wherein record values need to be displayed as 1 column

The below query returns 4 records.

Select document_id from fnd_attached_documents where pk1_value = '30393'

Present Output is:

Document Id:

9841912

9841914

9841917

9841919

The requirement is to display as shown below:

Document Id:

"9841912","9841914","9841917","9841919"

Please let me know how to achieve this output.


Thanks,

Krishna
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2015
Added on Nov 4 2015
10 comments
643 views