{"id":109,"date":"2009-05-29T15:17:03","date_gmt":"2009-05-29T07:17:03","guid":{"rendered":"http:\/\/www.genepeng.com\/?p=109"},"modified":"2009-05-29T15:17:03","modified_gmt":"2009-05-29T07:17:03","slug":"oracle%e5%8d%95%e5%bc%95%e5%8f%b7%e5%92%8c%e5%8f%8c%e5%bc%95%e5%8f%b7%e7%9a%84%e5%8c%ba%e5%88%ab%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/www.genepeng.com\/index.php\/109","title":{"rendered":"oracle\u5355\u5f15\u53f7\u548c\u53cc\u5f15\u53f7\u7684\u533a\u522b\uff1f"},"content":{"rendered":"

\u521d\u5b66oracle\uff0c\u4e0d\u77e5\u9053oracle\u5355\u5f15\u53f7\u548c\u53cc\u5f15\u53f7\u7684\u533a\u522b\uff0c\u5982\u4e0b\u9762\u4e24\u6761sql, \u4e0d\u77e5\u9053\u4e3a\u4ec0\u4e48\u7b2c\u4e8c\u6761\u4e0d\u6b63\u786e\uff0c\u5148\u8bb0\u4e0b\uff0c\u5e0c\u671b\u80fd\u5feb\u70b9\u89e3\u51b3\uff1a<\/p>\n

SQL> select ‘ab’ || ‘cd’ from dual;<\/span><\/p>\n

‘AB’<\/p>\n

—-<\/p>\n

abcd<\/p>\n

SQL> select “ab” || “cd” from dual;<\/span><\/p>\n

select “ab” || “cd” from dual<\/p>\n

*<\/p>\n

\u7b2c 1 \u884c\u51fa\u73b0\u9519\u8bef:<\/p>\n

ORA-00904: “cd”: \u6807\u8bc6\u7b26\u65e0\u6548<\/p>\n","protected":false},"excerpt":{"rendered":"

\u521d\u5b66oracle\uff0c\u4e0d\u77e5\u9053oracle\u5355\u5f15\u53f7\u548c\u53cc\u5f15\u53f7\u7684\u533a\u522b\uff0c\u5982\u4e0b\u9762\u4e24\u6761sql, \u4e0d\u77e5\u9053\u4e3a\u4ec0\u4e48\u7b2c\u4e8c\u6761\u4e0d\u6b63\u786e\uff0c\u5148\u8bb0\u4e0b\uff0c\u5e0c\u671b\u80fd\u5feb\u70b9\u89e3\u51b3\uff1a SQL> select ‘ab’ || ‘cd’ from dual; ‘AB’ —- abcd SQL> select “ab” || “cd” from dual; select “ab” || “cd” from dual * \u7b2c 1 \u884c\u51fa\u73b0\u9519\u8bef: ORA-00904: “cd”: \u6807\u8bc6\u7b26\u65e0\u6548<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8,3],"tags":[39],"_links":{"self":[{"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/posts\/109"}],"collection":[{"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/comments?post=109"}],"version-history":[{"count":2,"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/posts\/109\/revisions"}],"predecessor-version":[{"id":155,"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/posts\/109\/revisions\/155"}],"wp:attachment":[{"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/media?parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/categories?post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.genepeng.com\/index.php\/wp-json\/wp\/v2\/tags?post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}