Re: Dynamic SQL problem in Store Procedure
Thanks for this. But what I want to do is replace a single quote mark in my field with \'. the backslashes are only there to escape the single quote and the backslash I want to include with my single quote.
So where it finds ' in my field I want it to replace ' with \' instead. But this is within a dynamic sql statement in my procedure, so everything has to be double quoted. The problem I have is I'm not sure of the syntax.
replace(field_a,''''',''\''') I thought would have worked, but it doesn't. What's the correct syntax to replace a single quote with \' as part of my replace statement in a dyadic context.
Subject
Views
Written By
Posted
2229
July 13, 2012 06:55AM
1219
July 13, 2012 10:01AM
Re: Dynamic SQL problem in Store Procedure
1442
July 13, 2012 04:26PM
1118
July 13, 2012 10:04PM
1220
July 18, 2012 05:03AM
1171
July 18, 2012 09:54AM
950
September 30, 2012 02:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.