Oracle and the Ampersand (&)

iteye_16348

于 2008-06-10 09:35:42 发布

阅读量72

点赞数

文章标签： Oracle SQL

本文介绍了在Oracle数据库中正确插入特殊字符&的方法。通常使用的转义字符在此处不起作用。文章提供了一种可行的解决方案：通过字符串连接操作将&符号加入到数据中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[url]http://www.etstiles.com/?q=node/7[/url]
Oracle and the Ampersand (&)
Submitted by ets04uga on Tue, 11/06/2007 - 3:28pm.

* Ampersand
* Escape Character
* Oracle

So I was looking around and couldn't seem to find out how to insert ampersand into an Oracle XE database, outside of SQL*Plus as in the following example:

INSERT INTO TABLE (COL1) VALUE ('A & B');

Normally one might try the standard backslash('\') as an escape character. One would be wrong.

I'm not sure of every possible solution, but found a quick (and seemlingy dirty) solution where the ampersand needs to be at the end next to a single quote. The following is the current solution I am using until a betters/best approach is found:

INSERT INTO TABLE (COL1) VALUE ('A &'||' B');

Hope this helps.