On Apr 22, 5:00*am, Mountain... (AT) gmail (DOT) com wrote:
Quote:
This works with Oracle 10g XE and Mark's sample data:
This works a treat - many thanks.
Oaf |
Urs, yes very nice plus it finishes the job I started since by the
time I figured out the minor error I made while writing the query and
posted I left out the final pivot of the columns into rows.
-- Mark D Powell --