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!

Passing LISTAGG values into Incluase

PS SPJun 5 2021

I am able to get rows into columns following query :
select listagg(UC_SELECTED_COLUMN, ',' ) within group (order by UC_SELECTED_COLUMN) from TABLE_TEST group by UC_SELECTED_TABLE order by UC_SELECTED_TABLE;
In addition to this, i need to pass above query into In CLAUSE of another query. Can you please help me?

This post has been answered by Frank Kulash on Jun 5 2021

Jump to Answer

Added on Jun 5 2021

#pl-sql, #sql

2 comments

1,239 views

1 mention