How to create columns in pivot xml?

Question

Oracle

Please tell me how to create columns, because in the expression

... pivot xml ( count(field1) for field1 on ( тут любой запрос возвращает xml)

There is a return of xml, I tried to pull out the values ​​from there through extractvalue, but in the pivot it still returns xml, although if you run the query separately, then just a regular set of rows. In general, please show a working example of how to build columns from pivot xml.