开发者

updating speacial characters into database

I have string with many & and | operators . If I try to update such a string into database it asks me for a value . For e.g if i try to update a string A&B oracle asks me for a value . I want to st开发者_JS百科ore the string as A&B


If you have this problem using SQL*Plus as a client, you should first give this command:

set define off

With set define you can also change the substitution character (&).


You can also define an escape character and use it, for example:

SET ESCAPE '\'

SELECT 'A\&B' FROM companies;

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜