commaseperated values

[sona]

hai,

like can i do the following

to get The values of a single specified column in the table
to be stored in a string as commaseperated

eg:

empnames='dons,deepa,sona,..' (these are the valuesin the column)

[bensr]

There is a build-in package : DBMS_UTILITY
This should be able to solve your problem

TABLE_TO_COMMA Procedure
This procedure converts a PL/SQL table of names into a comma-separated list of names. This takes a PL/SQL table, 1..n,
terminated with n+1 null.
Syntax
DBMS_UTILITY.TABLE_TO_COMMA (
tab IN UNCL_ARRAY,
tablen OUT BINARY_INTEGER,
list OUT VARCHAR2);

[sona]

i want the values of a singlecolumn in the table in a comma seperated string