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)
Printable View
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)
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);
i want the values of a singlecolumn in the table in a comma seperated string