Oracle 10g-插入语句中的转义引号 [英] Oracle 10g - Escape quote in insert statement

问题描述

我正在尝试以5'9的形式将人们的身高插入数据库中

I am trying to insert people's height into a database in the form of 5'9

我如何正确地将引号转义，以便可以执行此操作.到目前为止，我的插入语句看起来像这样.

How do I properly escape the quote so I can do this. My insert statement looks like this so far.

INSERT INTO height(id, height) 
VALUES(height-seq.nexval, '5\'9');

反斜杠显然不起作用，对于oracle我还是很陌生.谢谢

The backslash does not work obviously and I am pretty new to oracle. Thanks

推荐答案

Oracle使用标准SQL:

Oracle uses standard SQL:

INSERT INTO height(id, height) 
VALUES(height-seq.nexval, '5''9');

(是，有两个单引号)

这篇关于Oracle 10g-插入语句中的转义引号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！