Oracle Insert & Character insertion issues

For example, execute a statement:

Insert  intonsrxt_sp (sp_id, Sp_title, Sp_desc, Sp_url, Sp_type, Sp_sub_type , Add_time, CZRY_DM)Values(227,'"Reminder" New income tax returns fill in Tips',NULL,'http://hdsw.wangzhanbaomu.com/index.php?g=wap&m=index&a=content&id=561&classid=79& Token=tnxjwh1411757286&wecha_id=ocyfxjjvqn69ytfpvkt2eui_y6ja','2',' ', To_date ('21-07-2015 11:07:58','dd-mm-yyyy Hh24:mi:ss'),NULL);

The Sp_url field corresponds to a hyperlink with parameters that Oracle handles & as a custom variable during execution.

Workaround:

(1) Online Some people say by setting set define OFF, to solve, but I still do not;

(2) Processing & using the Oracle character processing function Chr (this method succeeds): Chr (38) represents the & character

Insert  intonsrxt_sp (sp_id, Sp_title, Sp_desc, Sp_url, Sp_type, Sp_sub_type , Add_time, CZRY_DM)Values(227,'"Reminder" New income tax returns fill in Tips',NULL,'Http://hdsw.wangzhanbaomu.com/index.php?g=Wap'||Chr -)||'M=index'||Chr -)||'a=content'||Chr -)||'id=561'||Chr -)||'classid=79'||Chr -)||'token=tnxjwh1411757286'||Chr -)||'Wecha_id=ocyfxjjvqn69ytfpvkt2eui_y6ja','2',' ', To_date ('21-07-2015 11:07:58','dd-mm-yyyy Hh24:mi:ss'),NULL);

Oracle Insert & Character insertion issues