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!

SQL Query to fetch the multiple values that too in quotes as a single string

BommiNov 28 2017 — edited Nov 29 2017

Hi Experts,

Can anyone share a query which fetches the outputs of multiple Accounts as a single value that too in single quotes.

Example, we have accounts 42201,43001,48946... I want a sql query which fetches the output as

'42201','43001','48946'

Can anyone one has idea on how to achieve this? We want all this in single column(single string)

Thanks in Advance,

Srivathsava
This post has been answered by Gaz in Oz on Nov 29 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 27 2017
Added on Nov 28 2017
8 comments
743 views