oracle 中 &的转义
INSERT INTO SYS_CD ( CAIDANBIANHAO, CAIDANMINGCHENG, CAIDANMIAOSHU, CAIDANLIANJIE,
CHENGXULIEBIAO,
XITONGBAOLIU, SHIFOUQIYONG ) VALUES (
40099, '单位基础信息', '查询', '/nbxt/query?actionRes=cx_nbdw_index&funcId=0',
NULL
, '1', '0')
想吧‘&'号保存到数据库中
应该写成:
INSERT INTO SYS_CD ( CAIDANBIANHAO, CAIDANMINGCHENG, CAIDANMIAOSHU, CAIDANLIANJIE, CHENGXULIEBIAO, XITONGBAOLIU, SHIFOUQIYONG )
VALUES ( 40099, '单位基础信息', '查询', '/nbxt/query?actionRes=cx_nbdw_index'||'&'||'funcId=0', NULL , '1', '0')
其中&表示接受键盘输入的变量,需要转义 '||’&'||’