{"id":1952,"date":"2017-03-22T20:25:30","date_gmt":"2017-03-22T12:25:30","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=1952"},"modified":"2017-03-22T20:25:30","modified_gmt":"2017-03-22T12:25:30","slug":"sybase%e4%b8%8eoracle%e7%9a%84%e5%8c%ba%e5%88%ab%e5%b0%8f%e7%bb%93","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/shujuku\/sybase%e4%b8%8eoracle%e7%9a%84%e5%8c%ba%e5%88%ab%e5%b0%8f%e7%bb%93\/","title":{"rendered":"sybase\u4e0eoracle\u7684\u533a\u522b\u5c0f\u7ed3"},"content":{"rendered":"
1.Oracle\u8868\u540d\u3001\u5b57\u6bb5\u540d\u4e0d\u533a\u5206\u5927\u5c0f\u5199\uff0cSybase\u4e25\u683c\u533a\u5206\u00a0<\/div>\n
2.Oracle\u4e2dto_char()\/to_date() —Sybase\u7684convert()\u00a0<\/div>\n
\u00a0 –Oracle:to_char(sysdate,’dd-mm-yyyy day’),to_date(string,format)\u00a0<\/div>\n
\u00a0 –Sybase:convert(char(15),\u65e5\u671f,108),convert(datetime,string,108)\u00a0<\/div>\n
\u00a0 –\u672b\u5c3e\u9644 Sybase convert\u7b2c\u4e09\u4e2a\u53c2\u6570\u4ecb\u7ecd\u00a0<\/div>\n
3.Oracle\u4e2d substr() — Sybase\u7684 substring()\u00a0<\/div>\n
4.Oracle\u4e2d nvl() — Sybase\u7684 isnull()\u00a0<\/div>\n
5.Oracle\u53d6\u7cfb\u7edf\u65f6\u95f4 sysdate — Sybase\u7684 getdate()\u00a0<\/div>\n
6.Oracle\u7684decode — Sybase\u7684 case when then\u00a0<\/div>\n
\u00a0 –Oracle: select decode(param,null,resultA,resultB) from res;\u00a0<\/div>\n
\u00a0 –Sybase:select case when \u00a0param is null then resultA else resultB\u00a0<\/div>\n
<\/div>\n
end from res;\u00a0<\/div>\n
7.\u5916\u8fde\u63a5\u00a0<\/div>\n
\u00a0 –Oracle:select * from tableA a ,tableB b where a.id=b.id(+);\u00a0<\/div>\n
\u00a0 –Sybase:select * from tableA a,tableB b where a.id*=b.id;\u00a0<\/div>\n
8.insert \u65b9\u6cd5\u00a0<\/div>\n
\u00a0 –Oracle:insert into tableA(select * from tableB where tableB.id=””);\u00a0<\/div>\n
\u00a0 –Sybase:insert into tableA(id,name,age)(select * from tableB where\u00a0<\/div>\n
<\/div>\n
tableB.id=””); insert\u7684\u8868\u5fc5\u987b\u5199\u6e05\u5217\u540d\u00a0<\/div>\n
<\/div>\n
\u9644\uff1aSybase convert\u7b2c\u4e09\u4e2a\u53c2\u6570\u4ecb\u7ecd \u00a0\u00a0<\/span><\/b><\/div>\n
\u00a0 \u90a3\u662f\u8bf4\u660e\u4f60\u5728\u628a\u65f6\u95f4\u8f6c\u5316\u4e3a\u5b57\u7b26\u4e32\u884c\u65f6\u6240\u8981\u4fdd\u5b58\u7684\u683c\u5f0f \u00a0\u00a0<\/div>\n
\u00a0 101 \u00a0 USA \u00a0 mm\/dd\/yy \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 102 \u00a0 ANSI \u00a0 yy.mm.dd \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 103 \u00a0 British\/French \u00a0 dd\/mm\/yy \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 104 \u00a0 German \u00a0 dd.mm.yy \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 105 \u00a0 Italian \u00a0 dd-mm-yy \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 106 \u00a0 – \u00a0 dd \u00a0 mon \u00a0 yy \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 107 \u00a0 – \u00a0 Mon \u00a0 dd, \u00a0 yy \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 108 \u00a0 – \u00a0 hh:mm:ss \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 109 \u00a0 (*) \u00a0 \u00a0 Default \u00a0 + \u00a0 milliseconds \u00a0 mon \u00a0 dd \u00a0 yyyy \u00a0\u00a0<\/div>\n
<\/div>\n
hh:mi:ss:mmmAM \u00a0 (or \u00a0 PM) \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 110 \u00a0 USA \u00a0 mm-dd-yy \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 111 \u00a0 JAPAN \u00a0 yy\/mm\/dd \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 112 \u00a0 ISO \u00a0 yymmdd \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 113 \u00a0 (*) \u00a0 \u00a0 Europe \u00a0 default \u00a0 + \u00a0 milliseconds \u00a0 dd \u00a0 mon \u00a0 yyyy \u00a0\u00a0<\/div>\n
<\/div>\n
hh:mm:ss:mmm(24h) \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 114 \u00a0 – \u00a0 hh:mi:ss:mmm(24h) \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 120 \u00a0 (*) \u00a0 \u00a0 ODBC \u00a0 canonical \u00a0 yyyy-mm-dd \u00a0 hh:mi:ss(24h) \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 121 \u00a0 (*) \u00a0 \u00a0 ODBC \u00a0 canonical \u00a0 (with \u00a0 milliseconds) \u00a0 yyyy-mm-dd \u00a0\u00a0<\/div>\n
<\/div>\n
hh:mi:ss.mmm(24h) \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 126(***) \u00a0 ISO8601 \u00a0 yyyy-mm-dd \u00a0 Thh:mm:ss:mmm(no \u00a0 spaces) \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 130* \u00a0 Kuwaiti \u00a0 dd \u00a0 mon \u00a0 yyyy \u00a0 hh:mi:ss:mmmAM \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 131* \u00a0 Kuwaiti \u00a0 dd\/mm\/yy \u00a0 hh:mi:ss:mmmAM\u00a0<\/div>\n","protected":false},"excerpt":{"rendered":"

1.Oracle\u8868\u540d\u3001\u5b57\u6bb5\u540d\u4e0d\u533a\u5206\u5927\u5c0f\u5199\uff0cSybase\u4e25\u683c\u533a\u5206\u00a0 2.Oracle\u4e2dto_char()\/to_ … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10,21],"tags":[],"class_list":["post-1952","post","type-post","status-publish","format-standard","hentry","category-shujuku","category-yidong"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1952","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=1952"}],"version-history":[{"count":1,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1952\/revisions"}],"predecessor-version":[{"id":1953,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1952\/revisions\/1953"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=1952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=1952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=1952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}