6 Replies Latest reply: Jan 23, 2014 5:24 AM by 913349 RSS

    how to make a generic function ?


      Hi all,

      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.