avatar
a question about SQL# Database - 数据库
e*r
1
How to insert a "'" character into the table since "''" stands for enter
VARCHAR2 type data? Thanks.
It's something like this:
insert into soft values (7005,'NOTE: This upgrade requires ownership of a
JavaScript debugger,Integrated O'Reilly code reference.');
~
That is this character.
avatar
a*a
2
use chr(xxx) ?

【在 e******r 的大作中提到】
: How to insert a "'" character into the table since "''" stands for enter
: VARCHAR2 type data? Thanks.
: It's something like this:
: insert into soft values (7005,'NOTE: This upgrade requires ownership of a
: JavaScript debugger,Integrated O'Reilly code reference.');
: ~
: That is this character.

avatar
d*o
3
' = ''''

a

【在 e******r 的大作中提到】
: How to insert a "'" character into the table since "''" stands for enter
: VARCHAR2 type data? Thanks.
: It's something like this:
: insert into soft values (7005,'NOTE: This upgrade requires ownership of a
: JavaScript debugger,Integrated O'Reilly code reference.');
: ~
: That is this character.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。