Sql Question

[kranti pushkarna]

Hi List,             Can someone give a SQL query to retuen all values in paricular column in comma separed format. e.g. suppose I fire "select deptno from dept" the output would be like   Deptno 10 20 30 40   I want the output like 10,20,30,40.   I am just wondering can it be done in a single query.     TIA Kranti