-
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);
Regards
Ben de Boer
-
i want the values of a singlecolumn in the table in a comma seperated string
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|