Is it possible to somehow dynamically form a pivot?

Question

SQL

Is it possible to somehow dynamically form what is after FOR IN ?

select * from (
   select times_purchased as "Puchase Frequency", state_code
   from customers t
)
pivot 
(
   count(state_code)
   for state_code in ('NY' as "New York",'CT' "Connecticut",'NJ' "New Jersey",'FL' "Florida")
)
order by 1

Here are the values

'NY' as "New York",'CT' "Connecticut",'NJ' "New Jersey",'FL' "Florida"

I have them stored in a separate cities table , I can pull them out with select, so I don’t really want to write them explicitly in pivot.
I tried to substitute such a query after FOR :

SELECT
  LISTAGG( city , ',') WITHIN GROUP (ORDER BY ID) city
FROM cities

Oracle, of course, did not gobble it up.
How can you do?
https://www.oracle.com/technical-resources/article...

Answer 1

Not sure, but most likely not. Can be solved through dynamic sql.