单引号 ' 的编码是39,所以拼接字符串可以这样写 [sql] view plain copy str := 'select * from user where name='||chr(39)||zhangsan||chr(39)||' order by id'; execute immediate str; 原文