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

    how to make a generic function ?

    913349

      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.

       

      Thanks

      Damby