Sql文件中有语句是:
insert into MENU (MENU_ID, MENU_NAME, MENU_LEVEL, MENU_URL, PARENT_MENU_ID, MENU_ICON, TARGET, CHILD_COUNT, MENU_ORDER)
values (50, '', 1, './codingSetAction.do?method=displayIndex&tableId=1', 49, null, null, 0, 1);在Dos窗口执行到上面语句后提示:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining optionsEnter value for tableid:
insert into MENU (MENU_ID, MENU_NAME, MENU_LEVEL, MENU_URL, PARENT_MENU_ID, MENU_ICON, TARGET, CHILD_COUNT, MENU_ORDER)
values (50, '', 1, './codingSetAction.do?method=displayIndex&tableId=1', 49, null, null, 0, 1);在Dos窗口执行到上面语句后提示:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining optionsEnter value for tableid:
set define off
2. 字符值分开写
'./codingSetAction.do?method=displayIndex&'||'tableId=1'
3.将&用chr(38)代替就不会出现上面的问题了。
2. 字符值分开写
'./codingSetAction.do?method=displayIndex& ' ¦ ¦ 'tableId=1 '
好用随便问一下:
为什么会在Dos窗口上面有那些提示信息?
values (50, ' ', 1, './codingSetAction.do?method=displayIndex' || '&' || 'tableId=1 ', 49, null, null, 0, 1); chr(38)也可以.
会出现要求输入的画面。