update HT_RQMT set SEC_PAY_CONTENT =
'
Ten percent (10%) of payment basis, shall be paid by the Buyer to the Seller after the date of completion of test run and upon the Buyer's Bank has received the following documents and found them in order
1)
Ten percent (10%) of payment basis, shall be paid by the Buyer to the Seller after the date of completion of test run and upon the Buyer's Bank has received the following documents and found them in order
Four (4) originals of Commercial invoice, covering 10% of payment basis;
'
where RQMT_ID='12345679'因为字符串中有两个Buyer's带单引号,所以这个语句执行不了,求大侠解救SQLUPDATESQL中单引号问题
'
Ten percent (10%) of payment basis, shall be paid by the Buyer to the Seller after the date of completion of test run and upon the Buyer's Bank has received the following documents and found them in order
1)
Ten percent (10%) of payment basis, shall be paid by the Buyer to the Seller after the date of completion of test run and upon the Buyer's Bank has received the following documents and found them in order
Four (4) originals of Commercial invoice, covering 10% of payment basis;
'
where RQMT_ID='12345679'因为字符串中有两个Buyer's带单引号,所以这个语句执行不了,求大侠解救SQLUPDATESQL中单引号问题
解决方案 »
- oracle References
- 求助写sql语句,各位达人来!
- sele语句怎样查询oracle表中不重复的记录?
- jdbc连接oracl时报invalid number format for port 1521
- Oracle 11g 中to_date() 请教
- 请问大家这个sql语句怎么写呢
- 高分急切求教关于"Escape"莫名报"ora-01424"错误的问题!!!
- oracle安装问题,无法启动安装程序
- 关于数据库和表的问题,谢谢!在线等待!
- 为什么我的plsql developer连接远程数据库之后,无法连接本地oracle
- 求助一个问题,如何让两个字段同时不等于某两个值
- pl\sql 行列转换问题
update HT_RQMT set SEC_PAY_CONTENT =
'
Ten percent (10%) of payment basis, shall be paid by the Buyer to the Seller after the date of completion of test run and upon the Buyer''s Bank has received the following documents and found them in order
1)
Ten percent (10%) of payment basis, shall be paid by the Buyer to the Seller after the date of completion of test run and upon the Buyer''s Bank has received the following documents and found them in order
Four (4) originals of Commercial invoice, covering 10% of payment basis;
'
where RQMT_ID='12345679';or update HT_RQMT set SEC_PAY_CONTENT =
'
Ten percent (10%) of payment basis, shall be paid by the Buyer to the Seller after the date of completion of test run and upon the Buyer||''||s Bank has received the following documents and found them in order
1)
Ten percent (10%) of payment basis, shall be paid by the Buyer to the Seller after the date of completion of test run and upon the Buyer||''||s Bank has received the following documents and found them in order
Four (4) originals of Commercial invoice, covering 10% of payment basis;
'
where RQMT_ID='12345679';