Skip to Main Content

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!

stragg distinct

683463Aug 31 2010 — edited Aug 31 2010
Hello.
I have a question about STRAGG (or wm_concat or any similar) function. I need that STRAGG function returns only distinct values in a row.
My idea was:

select
col1,
stragg(distinct col2)
from
my_table
group by
col1

this select works perfect, but if a have this select in a package, complilation of this package returns ERORR!! PL/SQL: ORA-30482: DISTINCT option not allowed for this function.
What can I do? Is there any other way to get unigue data in stragg output?


Thanks.
This post has been answered by MichaelS on Aug 31 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2010
Added on Aug 31 2010
5 comments
3,921 views