Having a query return a comma-delimited list
Hi there!
I have the following query
SELECT category_name FROM item_categories, categories
WHERE item_categories.item_id = 10001 AND categories.language_id = 1 AND
item_categories.category_id = categories.category_id
which works as expected and returns a list of category names.
Now I was wondering if it's possible to instead have it return a single row with one column containing all category names as a comma-delimited list.
I have experimented with this for a while and I'm getting the impression that this is in fact not possible, but I'd like to make sure it actually can't be done (easily and effectively) before I give up on it.
Thanks in advance!
Subject
Written By
Posted
Having a query return a comma-delimited list
July 10, 2005 03:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.