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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Let us discussion at wmsys.wm_concat VS ListAgg

Aketi JyuuzouJun 18 2010 — edited Jun 17 2011
This thread is to discussion what is difference between wmsys.wm_concat and ListAgg. B-)

*************************************************************************
difference1 :-)

wmsys.wm_concat allows distinct option.
ListAgg does not allows it.
create table diffT(sortKey,Val) as
select 1,'aa' from dual union all
select 2,'bb' from dual union all
select 3,'aa' from dual union all
select 4,'dd' from dual;

col concatV for a20

select wmsys.wm_concat(distinct Val) as concatV from diffT;

concatV 
--------
aa,bb,dd
*************************************************************************
difference2 :-)

ListAgg allows to decide string concat order.
wmsys.wm_concat does not allows it.
select ListAgg(Val,',')
       within group(order by sortKey desc) as concatV
from diffT;

CONCATV
------------
dd,aa,bb,aa 
*************************************************************************
difference3 :-)

ListAgg allows to decide delimiter.
wmsys.wm_concat does not allows it.
select ListAgg(Val,'***')
       within group(order by sortKey desc) as concatV
from diffT;

CONCATV
-----------------
dd***aa***bb***aa
*************************************************************************
difference4 :-)

wmsys.wm_concat allows to be used OLAP function with order by
ListAgg does not allows it.
ListAgg allows only OLAP function without order by.
select sortKey,wmsys.wm_concat(Val)
               over(order by sortKey) as concatV
  from diffT;

SORTKEY  CONCATV
-------  -----------
      1  aa
      2  aa,bb
      3  aa,bb,aa
      4  aa,bb,aa,dd
*************************************************************************
difference5 :-)

wmsys.wm_concat allows to be used KEEP
ListAgg does not allows it.
select wmsys.wm_concat(Val) 
       Keep(Dense_Rank First order by Val) as concatV 
  from diffT;

CONCATV
-------
aa,aa

Comments

James_D
Answer

The popup portion of the ComboBox is represented by a PopupControl. This is a subclass of Window, so it's not constrained by the bounds of the window in which the ComboBox is placed.

Marked as Answer by 1056224 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 15 2011
Added on Jun 18 2010
18 comments
34,752 views