This content has been marked as final. Show 6 replies
I am am using oracle 11g.
my question is how can i make generic function to escape some special charecters.
currently i am using this way.
select replace(replace(replace(FACILITY_ADDRESS,'\' , '\\\\' ),'''' , '\''' ),'"' , '\\"' ) from facility;
above i am giving for one column , similarly i am doing for some more columns
so i need a generic function and i will use that function in every columns based on the condition.