语句如下
UPDATE STDCMP_REC SET ENGLISH = 'Cold & Cool School (TCM)' WHERE ID = 8260;
用sqlplus执行,提示enter value for cool,我按回车,然后这个字段最后再我查询的时候就成了Cold School (TCM),显然把& Cool当作一个变量了,这个问题是怎么回事??
UPDATE STDCMP_REC SET ENGLISH = 'Cold & Cool School (TCM)' WHERE ID = 8260;
用sqlplus执行,提示enter value for cool,我按回车,然后这个字段最后再我查询的时候就成了Cold School (TCM),显然把& Cool当作一个变量了,这个问题是怎么回事??
UPDATE STDCMP_REC SET ENGLISH = 'Cold \& Cool School (TCM)' WHERE ID = 8260;使用转义字符\来将字符&转义 从而不把Cool作为变量处理前提是在SQL*PLUS中输入set escape on打开转义字符
SQL> create table test (id number,name varchar2(64));表已创建。SQL> insert into test values (8260,'');已创建 1 行。SQL> commit;提交完成。SQL> select * from test; ID NAME
---------- ----------------------------------------------------------------
8260SQL> update test set name='Cold '||'&'||'Cool School (TCM)' WHERE ID = 8260;已更新 1 行。SQL> commit;提交完成。SQL> select * from test; ID NAME
---------- ----------------------------------------------------------------
8260 Cold &Cool School (TCM)SQL>
2 ; ID NAME
---------- ----------------------------------------------------------------
8260 Cold &Cool School (TCM)
1 AC米兰SQL> update test set name='Cold '||chr(38)||'Cool School (TCM)' WHERE ID =1;已更新 1 行。SQL> commit;提交完成。SQL> select * from test; ID NAME
---------- ----------------------------------------------------------------
8260 Cold &Cool School (TCM)
1 Cold &Cool School (TCM)SQL>
还有请问,oracle里执行几万行这个数量的sql语句时如何查看执行结果啊~
我是个oracle菜鸟,吼吼
sql1
sql2
.....spool off然后检查日志文件,是否有错误信息。
或者,如果执行期间,未提示任何错误,则说明执行成功。