Hi all,

I have a string with comma separated into single quoted string

For example v_str:=A,B,C
Need to convert into v_str1:='A','B','C'
Tried to use the replace function to replace , with ','
And then append the former and latter part of string with single quotes
to get the required string 'A','B','C'
str1:= replace(v_str,',','','');
The replace function does not do it .
How to use the replace function for this type of conversion
How to escape the single quotes within the replace function.

Doing such conversion to pass it in where clause.

Thanks in advance.

Regards,
Aashish
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------

Oracle LazyDBA home page