{"id":360,"date":"2011-11-24T08:11:31","date_gmt":"2011-11-24T00:11:31","guid":{"rendered":"https:\/\/blog.rexdf.org\/?p=360"},"modified":"2011-11-24T08:11:31","modified_gmt":"2011-11-24T00:11:31","slug":"oracle-%e4%b8%ad%e4%bd%bf%e7%94%a8%e5%8d%95%e5%bc%95%e5%8f%b7%e5%92%8c%e5%8f%8c%e5%bc%95%e5%8f%b7","status":"publish","type":"post","link":"https:\/\/blog.rexdf.org\/en\/2011\/11\/oracle-%e4%b8%ad%e4%bd%bf%e7%94%a8%e5%8d%95%e5%bc%95%e5%8f%b7%e5%92%8c%e5%8f%8c%e5%bc%95%e5%8f%b7\/","title":{"rendered":"oracle \u4e2d\u4f7f\u7528\u5355\u5f15\u53f7(‘)\u548c\u53cc\u5f15\u53f7(“)"},"content":{"rendered":"
    \n
  1. \u5728ORACLE\u4e2d\uff0c\u5355\u5f15\u53f7\u6709\u4e24\u4e2a\u4f5c\u7528:\u00a0\u00a0<\/span><\/span><\/li>\n
  2. \u00a0\u00a01:\u5b57\u7b26\u4e32\u662f\u7531\u5355\u5f15\u53f7\u5f15\u7528\u00a0\u00a0<\/span><\/li>\n
  3. \u00a0\u00a02:\u8f6c\u4e49\u3002\u00a0\u00a0<\/span><\/li>\n
  4. \u5355\u5f15\u53f7\u7684\u4f7f\u7528\u662f\u5c31\u8fd1\u914d\u5bf9\uff0c\u5373\u5c31\u8fd1\u539f\u5219\u3002\u800c\u5728\u5355\u5f15\u53f7\u5145\u5f53\u8f6c\u4e49\u89d2\u8272\u65f6\u76f8\u5bf9\u4e0d\u597d\u7406\u89e3\u00a0\u00a0<\/span><\/li>\n
  5. 1.\u4ece\u7b2c\u4e8c\u4e2a\u5355\u5f15\u53f7\u5f00\u59cb\u88ab\u89c6\u4e3a\u8f6c\u4e49\u7b26\uff0c\u5982\u679c\u7b2c\u4e8c\u4e2a\u5355\u5f15\u53f7\u540e\u9762\u8fd8\u6709\u5355\u5f15\u53f7\uff08\u54ea\u6015\u53ea\u6709\u4e00\u4e2a\uff09\u3002\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/li>\n
  6. SQL>\u00a0select\u00a0”<\/span>”<\/span>\u00a0result\u00a0from\u00a0dual;\u00a0\u00a0<\/span><\/span><\/li>\n
  7. RESULT\u00a0\u00a0<\/span><\/li>\n
  8. ——\u00a0\u00a0<\/span><\/li>\n
  9. ‘\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/li>\n
  10. \u7b2c\u4e8c\u4e2a\u5355\u5f15\u53f7\u88ab\u4f5c\u4e3a\u8f6c\u4e49\u7b26,\u7b2c\u4e09\u4e2a\u5355\u5f15\u53f7\u88ab\u8f6c\u4e49,\u53ef\u5c06sql\u5199\u6210\u8fd9\u6837\u66f4\u597d\u7406\u89e3:\u00a0\u00a0<\/span><\/li>\n
  11. select\u00a0‘\u00a0‘<\/span>‘\u00a0‘<\/span>\u00a0from\u00a0dual;\u00a0\u00a0<\/span><\/span><\/li>\n
  12. output:’\u00a0\u00a0<\/span><\/li>\n
  13. \/\/<\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  14. 2.\u8fde\u63a5\u7b26\u2018||\u2019\u5bfc\u81f4\u4e86\u65b0\u4e00\u8f6e\u7684\u8f6c\u4e49\uff1a\u00a0\u00a0<\/span><\/li>\n
  15. \u00a0\u00a0\u8fde\u63a5\u7b26\u53f7\u2018||\u2019\u5de6\u53f3\u7684\u5355\u5f15\u53f7\u6ca1\u6709\u4efb\u4f55\u7684\u5173\u7cfb\uff0c\u00a0\u00a0<\/span><\/li>\n
  16. \u00a0\u00a0\u9664\u975e\u2018||\u2019\u662f\u4f5c\u4e3a\u5b57\u7b26\u4e32\u7684\u4e00\u90e8\u5206\uff08\u8fd9\u5728\u52a8\u6001SQL\u4e2d\u5f88\u5e38\u89c1\uff09\u3002\u00a0\u00a0<\/span><\/li>\n
  17. SQL>\u00a0select\u00a0‘name’<\/span>||<\/span>”<\/span>”<\/span>\u00a0result\u00a0from\u00a0dual;\u00a0\u00a0<\/span><\/span><\/li>\n
  18. RESULT\u00a0\u00a0<\/span><\/li>\n
  19. ——\u00a0\u00a0<\/span><\/li>\n
  20. name’\u00a0\u00a0\u00a0<\/span><\/li>\n
  21. \u7406\u89e3:||\u540e\u9762\u7684\u4f5c\u4e3a\u4e00\u4e2a\u5b57\u7b26\u4e32,\u5373\u524d\u540e\u662f‘,\u4e2d\u95f4\u53c8\u662f\u4e00\u4e2a\u5bc6\u96c6\u578b\u5355\u5f15\u53f7\u4e32’<\/span>‘,\u56e0\u6b64\u7b2c\u4e00\u4e2a\u4e3a\u8f6c\u4e49\u529f\u80fd.\u00a0\u00a0<\/span><\/span><\/li>\n
  22. SQL>\u00a0select\u00a0‘name’<\/span>”<\/span>”<\/span>\u00a0result\u00a0from\u00a0dual;\u00a0\u00a0<\/span><\/span><\/li>\n
  23. RESULT\u00a0\u00a0<\/span><\/li>\n
  24. ——\u00a0\u00a0<\/span><\/li>\n
  25. name”<\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  26. \u7b2c\u4e00\u4e2a\u548c\u6700\u540e\u4e00\u4e2a\u5355\u5f15\u53f7\u4f5c\u4e3a\u5b57\u7b26\u4e32\u5f15\u7528\u7b26,\u4e2d\u95f4\u56db\u4e2a\u5355\u5f15\u53f7\u4e24\u4e24\u8f6c\u4e49.\u00a0\u00a0<\/span><\/li>\n
  27. \/\/<\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  28. oracle\u4e2d\u4f7f\u7528\u53cc\u5f15\u53f7\uff1a\u00a0\u00a0<\/span><\/li>\n
  29. 1)\u4e00\u822c\u6765\u8bf4\uff0c\u5b57\u7b26\u4e32\u4e2d\u7684\u53cc\u5f15\u53f7\u4ec5\u4ec5\u88ab\u5f53\u4f5c\u4e00\u4e2a\u666e\u901a\u5b57\u7b26\u8fdb\u884c\u5904\u7406\u3002\u00a0\u00a0<\/span><\/li>\n
  30. \u6b64\u65f6\uff0c\u53cc\u5f15\u53f7\u4e0d\u9700\u8981\u6210\u5bf9\u51fa\u73b0\uff1a\u00a0\u00a0<\/span><\/li>\n
  31. SQL>\u00a0select\u00a0‘hh24″\u5c0f\u65f6””mi””\u5206”””ss”\u79d2”‘<\/span>\u00a0results\u00a0from\u00a0dual;\u00a0\u00a0<\/span><\/span><\/li>\n
  32. RESULTS\u00a0\u00a0<\/span><\/li>\n
  33. ————————-\u00a0\u00a0<\/span><\/li>\n
  34. hh24“\u5c0f\u65f6”<\/span>“mi”<\/span>“\u5206”<\/span>“”<\/span>ss<\/span>“\u79d2”<\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  35. \/\/<\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  36. 2)\u5f53\u51fa\u73b0\u5728to_char\u7684\u683c\u5f0f\u5b57\u7b26\u4e32\u4e2d\u65f6\uff0c\u53cc\u5f15\u53f7\u6709\u7279\u6b8a\u7684\u4f5c\u7528\uff0c\u00a0\u00a0<\/span><\/li>\n
  37. \u5c31\u662f\u5c06\u975e\u6cd5\u7684\u683c\u5f0f\u7b26\u5305\u88c5\u8d77\u6765\uff0c\u907f\u514d\u51fa\u73b0ORA-01821:\u00a0date\u00a0format\u00a0not\u00a0recognized\u9519\u8bef\u3002\u00a0\u00a0<\/span><\/li>\n
  38. \u4e5f\u5c31\u662f\u8bf4\uff0c\u53bb\u6389\u53cc\u5f15\u53f7\u548c\u5176\u5305\u542b\u7684\u5b57\u7b26\u540e\uff0c\u5269\u4e0b\u7684\u5e94\u8be5\u662f\u4e00\u4e2a\u5408\u6cd5\u7684\u683c\u5f0f\u4e32\u3002\u00a0\u00a0<\/span><\/li>\n
  39. to_char\u5728\u5904\u7406\u683c\u5f0f\u5b57\u7b26\u4e32\u65f6\uff0c\u4f1a\u5ffd\u7565\u53cc\u5f15\u53f7\uff1a\u00a0\u00a0<\/span><\/li>\n
  40. SQL>\u00a0select\u00a0to_char(sysdate,‘hh24″\u5c0f\u65f6”mi”\u5206”ss”\u79d2”‘<\/span>)\u00a0results\u00a0from\u00a0dual;\u00a0\u00a0<\/span><\/span><\/li>\n
  41. RESULTS\u00a0\u00a0<\/span><\/li>\n
  42. ————–\u00a0\u00a0<\/span><\/li>\n
  43. 06\u5c0f\u65f639\u520651\u79d2\u00a0\u00a0<\/span><\/li>\n
  44. \/\/<\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  45. \u683c\u5f0f\u4e32\u4e3a‘hh24″\u5c0f\u65f6”mi”\u5206”ss”\u79d2”‘<\/span>\uff1b\u00a0\u00a0<\/span><\/span><\/li>\n
  46. \u53bb\u6389\u53cc\u5f15\u53f7\u90e8\u5206\u540e\uff0c\u5269\u4e0b\u7684\u662f‘hh24miss’<\/span>\uff0c\u662f\u4e00\u4e2a\u5408\u6cd5\u7684\u683c\u5f0f\u4e32\u3002\u00a0\u00a0<\/span><\/span><\/li>\n
  47. \u4e0d\u8fc7\u5373\u4f7f\u771f\u4e0d\u77e5\u9053\u53cc\u5f15\u53f7\u7684\u8fd9\u4e2a\u7528\u6cd5\uff0c\u4e5f\u53ef\u4ee5\u8fd9\u6837\u6765\u5904\u7406\uff0c\u867d\u7136\u9ebb\u70e6\u4e00\u70b9\uff1a\u00a0\u00a0<\/span><\/li>\n
  48. select\u00a0to_char(sysdate,\u00a0‘hh24’<\/span>)\u00a0||\u00a0<\/span>‘\u5c0f\u65f6’<\/span>\u00a0||\u00a0\u00a0<\/span><\/span><\/li>\n
  49. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0to_char(sysdate,\u00a0‘mi’<\/span>)\u00a0||\u00a0<\/span>‘\u5206’<\/span>\u00a0||\u00a0\u00a0<\/span><\/span><\/li>\n
  50. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0to_char(sysdate,\u00a0‘ss’<\/span>)\u00a0||\u00a0<\/span>‘\u79d2’<\/span>\u00a0\u00a0<\/span><\/span><\/li>\n
  51. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0AS\u00a0RESULT\u00a0\u00a0\u00a0<\/span><\/li>\n
  52. from\u00a0dual;\u00a0\u00a0<\/span><\/li>\n
  53. RESULT\u00a0\u00a0<\/span><\/li>\n
  54. ————–\u00a0\u00a0<\/span><\/li>\n
  55. 06\u5c0f\u65f640\u520618\u79d2\u00a0\u00a0<\/span><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    \u5728ORACLE\u4e2d\uff0c\u5355\u5f15\u53f7\u6709\u4e24\u4e2a\u4f5c\u7528:\u00a0\u00a0 \u00a0\u00a01:\u5b57\u7b26\u4e32\u662f\u7531\u5355\u5f15\u53f7\u5f15\u7528\u00a0\u00a0 \u00a0\u00a02:\u8f6c\u4e49\u3002\u00a0\u00a0 \u5355\u5f15\u53f7\u7684\u4f7f\u7528\u662f\u5c31\u8fd1\u914d\u5bf9\uff0c\u5373\u5c31\u8fd1\u539f\u5219\u3002\u800c\u5728\u5355\u5f15\u53f7\u5145\u5f53\u8f6c\u4e49\u89d2\u8272\u65f6\u76f8\u5bf9\u4e0d\u597d\u7406\u89e3\u00a0\u00a0 1.\u4ece\u7b2c\u4e8c\u4e2a\u5355\u5f15\u53f7\u5f00\u59cb\u88ab\u89c6\u4e3a\u8f6c\u4e49\u7b26\uff0c\u5982\u679c\u7b2c\u4e8c\u4e2a\u5355\u5f15\u53f7\u540e\u9762\u8fd8\u6709\u5355\u5f15\u53f7\uff08\u54ea\u6015\u53ea\u6709\u4e00\u4e2a\uff09\u3002\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL>\u00a0select\u00a0””\u00a0result\u00a0from\u00a0dual;\u00a0\u00a0 RESULT\u00a0\u00a0 ——\u00a0\u00a0 ‘\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u7b2c\u4e8c\u4e2a\u5355\u5f15\u53f7\u88ab\u4f5c\u4e3a\u8f6c\u4e49\u7b26,\u7b2c\u4e09\u4e2a\u5355\u5f15\u53f7\u88ab\u8f6c\u4e49,\u53ef\u5c06sql\u5199\u6210\u8fd9\u6837\u66f4\u597d\u7406\u89e3:\u00a0\u00a0 select\u00a0‘\u00a0‘‘\u00a0‘\u00a0from\u00a0dual;\u00a0\u00a0 output:’\u00a0\u00a0 \/\/\u00a0\u00a0 2.\u8fde\u63a5\u7b26\u2018||\u2019\u5bfc\u81f4\u4e86\u65b0\u4e00\u8f6e\u7684\u8f6c\u4e49\uff1a\u00a0\u00a0 \u00a0\u00a0\u8fde\u63a5\u7b26\u53f7\u2018||\u2019\u5de6\u53f3\u7684\u5355\u5f15\u53f7\u6ca1\u6709\u4efb\u4f55\u7684\u5173\u7cfb\uff0c\u00a0\u00a0 \u00a0\u00a0\u9664\u975e\u2018||\u2019\u662f\u4f5c\u4e3a\u5b57\u7b26\u4e32\u7684\u4e00\u90e8\u5206\uff08\u8fd9\u5728\u52a8\u6001SQL\u4e2d\u5f88\u5e38\u89c1\uff09\u3002\u00a0\u00a0 SQL>\u00a0select\u00a0‘name’||””\u00a0result\u00a0from\u00a0dual;\u00a0\u00a0 RESULT\u00a0\u00a0 ——\u00a0\u00a0 name’\u00a0\u00a0\u00a0 \u7406\u89e3:||\u540e\u9762\u7684\u4f5c\u4e3a\u4e00\u4e2a\u5b57\u7b26\u4e32,\u5373\u524d\u540e\u662f‘,\u4e2d\u95f4\u53c8\u662f\u4e00\u4e2a\u5bc6\u96c6\u578b\u5355\u5f15\u53f7\u4e32’‘,\u56e0\u6b64\u7b2c\u4e00\u4e2a\u4e3a\u8f6c\u4e49\u529f\u80fd.\u00a0\u00a0 SQL>\u00a0select\u00a0‘name’””\u00a0result\u00a0from\u00a0dual;\u00a0\u00a0 RESULT\u00a0\u00a0 ——\u00a0\u00a0 name”\u00a0\u00a0 \u7b2c\u4e00\u4e2a\u548c\u6700\u540e\u4e00\u4e2a\u5355\u5f15\u53f7\u4f5c\u4e3a\u5b57\u7b26\u4e32\u5f15\u7528\u7b26,\u4e2d\u95f4\u56db\u4e2a\u5355\u5f15\u53f7\u4e24\u4e24\u8f6c\u4e49.\u00a0\u00a0 \/\/\u00a0\u00a0 oracle\u4e2d\u4f7f\u7528\u53cc\u5f15\u53f7\uff1a\u00a0\u00a0 1)\u4e00\u822c\u6765\u8bf4\uff0c\u5b57\u7b26\u4e32\u4e2d\u7684\u53cc\u5f15\u53f7\u4ec5\u4ec5\u88ab\u5f53\u4f5c\u4e00\u4e2a\u666e\u901a\u5b57\u7b26\u8fdb\u884c\u5904\u7406\u3002\u00a0\u00a0 \u6b64\u65f6\uff0c\u53cc\u5f15\u53f7\u4e0d\u9700\u8981\u6210\u5bf9\u51fa\u73b0\uff1a\u00a0\u00a0 SQL>\u00a0select\u00a0‘hh24″\u5c0f\u65f6””mi””\u5206”””ss”\u79d2”‘\u00a0results\u00a0from\u00a0dual;\u00a0\u00a0 RESULTS\u00a0\u00a0 ————————-\u00a0\u00a0 hh24“\u5c0f\u65f6”“mi”“\u5206”“”ss“\u79d2”\u00a0\u00a0 \/\/\u00a0\u00a0 2)\u5f53\u51fa\u73b0\u5728to_char\u7684\u683c\u5f0f\u5b57\u7b26\u4e32\u4e2d\u65f6\uff0c\u53cc\u5f15\u53f7\u6709\u7279\u6b8a\u7684\u4f5c\u7528\uff0c\u00a0\u00a0 \u5c31\u662f\u5c06\u975e\u6cd5\u7684\u683c\u5f0f\u7b26\u5305\u88c5\u8d77\u6765\uff0c\u907f\u514d\u51fa\u73b0ORA-01821:\u00a0date\u00a0format\u00a0not\u00a0recognized\u9519\u8bef\u3002\u00a0\u00a0 \u4e5f\u5c31\u662f\u8bf4\uff0c\u53bb\u6389\u53cc\u5f15\u53f7\u548c\u5176\u5305\u542b\u7684\u5b57\u7b26\u540e\uff0c\u5269\u4e0b\u7684\u5e94\u8be5\u662f\u4e00\u4e2a\u5408\u6cd5\u7684\u683c\u5f0f\u4e32\u3002\u00a0\u00a0 to_char\u5728\u5904\u7406\u683c\u5f0f\u5b57\u7b26\u4e32\u65f6\uff0c\u4f1a\u5ffd\u7565\u53cc\u5f15\u53f7\uff1a\u00a0\u00a0 SQL>\u00a0select\u00a0to_char(sysdate,‘hh24″\u5c0f\u65f6”mi”\u5206”ss”\u79d2”‘)\u00a0results\u00a0from\u00a0dual;\u00a0\u00a0 … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6],"tags":[50],"class_list":["post-360","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-2"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/posts\/360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/comments?post=360"}],"version-history":[{"count":0,"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/posts\/360\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/media?parent=360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/categories?post=360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.rexdf.org\/en\/wp-json\/wp\/v2\/tags?post=360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}