2         substr(REPLACE(REPLACE(xmlagg(xmlelement("x", job) ORDER BY
job), '</x>'), '<x>', ' '), 2) job_list
3    FROM emp

I upgraded a Win2000 (SP4) server from Oracle 9i to 10.2.0.4. (It is a
SAP system, not
supported for Ora11).
The upgrade went well. I used DBUA. I can start the database in 10g.

Is there any free Oracle 10g database that will enable me to create
multiple databases, for testing purposes?
I tried 10g and it only comes with one database. Thank you, T

I'm trying to write a query that will combine multiple rows from the
same table into one row.  That can be done with each column being a
SELECT statement.
However, in my case each column has different criteria and I'm running