Try using chr(39).

Deepak

-----Original Message-----
From: Vinherkar Aashish C (MLITS)
[mailto:oracledba-ezmlmshield-x20123246.[Email address protected]
Sent: Monday, May 29, 2006 6:17 AM
To: LazyDBA Discussion
Subject: Problem replace function

Hi all,


I have a string with comma separated need to convert it 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'.

The replace function used is as follows;-
str1:= replace(v_str,',','','');
The replace function does not do it .
How to use the replace function for this type of conversion

I feel it is a problem because the single quotes need to be escaped by
using escape character

Doing such conversion to pass to IN 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/
--------------------------------------------------------


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page