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!

Store multiple values in CTE and use in another

SQLE KumarDec 21 2022 — edited Dec 21 2022

Hi All,
I have multiple CTE's and each CTE has where clause where we need to pass multiple customer id example 1,2,3,.....
Now to change the id in 10-12 cte's is a task has probability of error.
So, I am trying to store all customer id in 1 CTE maybe a variable and pass that variable in where caluse of other CTE.
Kindly help

This post has been answered by L. Fernigrini on Dec 26 2022
Jump to Answer
Comments
Post Details
Added on Dec 21 2022
5 comments
2,963 views