{"id":1028,"date":"2019-06-05T14:09:22","date_gmt":"2019-06-05T06:09:22","guid":{"rendered":"http:\/\/www.hefeiyu.com\/?p=1028"},"modified":"2019-06-05T14:09:22","modified_gmt":"2019-06-05T06:09:22","slug":"oracle-sql%e5%86%85%e7%bd%ae%e5%87%bd%e6%95%b0%e6%b5%8b%e8%af%95","status":"publish","type":"post","link":"https:\/\/www.hefeiyu.com\/?p=1028","title":{"rendered":"Oracle SQL\u5185\u7f6e\u51fd\u6570\u6d4b\u8bd5"},"content":{"rendered":"

Oracle SQL\u5185\u7f6e\u51fd\u6570<\/strong><\/p>\n

Oracle\u5185\u7f6eSQL\u51fd\u6570\u4e3b\u8981\u5206\u4e3a\u4e00\u4e0b\u7c7b\u522b\uff1a\u6570\u5b57\u51fd\u6570\u3001\u5b57\u7b26\u51fd\u6570\u3001\u65e5\u671f\u51fd\u6570\u3001\u8f6c\u6362\u51fd\u6570\u3001\u96c6\u5408\u51fd\u6570\u3001\u5206\u6790\/\u805a\u5408\u51fd\u6570<\/strong><\/p>\n

\u672c\u624b\u518c\u6240\u6709\u793a\u4f8b\u5747\u4ee5TIPTOP GP 5.10 ERP\u6570\u636e\u5e93\u8868\u4e3a\u57fa\u7840\u6f14\u793a<\/p>\n

 <\/p>\n

1\u3001\u6570\u5b57\u51fd\u6570<\/strong><\/p>\n

abs(n)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n\u7684\u7edd\u5bf9\u503c<\/p>\n

ceil(n)<\/strong>\uff1a\u8fd4\u56de>=\u6570\u5b57n\u7684\u6700\u5c0f\u6574\u6570<\/p>\n

floor(n)<\/strong>\uff1a\u8fd4\u56de<=\u6570\u5b57n\u7684\u6700\u5927\u6574\u6570<\/p>\n

round(n,[m])<\/strong>\uff1a\u56db\u820d\u4e94\u5165\u8fd0\u7b97,\u5982\u679cm\u7f3a\u7701\u5219\u56db\u820d\u4e94\u5165\u5230\u6574\u6570\u4f4d<\/p>\n

m<0,\u56db\u820d\u4e94\u5165\u5230\u5c0f\u6570\u70b9\u7684\u524dm\u4f4d,m>0\u56db\u820d\u4e94\u5165\u5230\u5c0f\u6570\u70b9\u7684\u540em\u4f4d<\/p>\n

trunc(n,[m])<\/strong>\uff1a\u622a\u53d6\u6570\u5b57,\u5982\u679cm\u7f3a\u7701\u5219\u5c06\u5c0f\u6570\u4f4d\u622a\u53bb<\/p>\n

m<0,\u622a\u53d6\u5230\u5c0f\u6570\u70b9\u7684\u524dm\u4f4d,m>0\u622a\u53d6\u5230\u5c0f\u6570\u70b9\u7684\u540em\u4f4d<\/p>\n

view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

    \n
  1. –demo\uff1aabs()\u3001ceil()\u3001floor()\u3001trunc()<\/li>\n
  2. SELECT\u00a0abs(-2.3),<\/li>\n
  3. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ceil(-2.6),ceil(2.6),<\/li>\n
  4. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0floor(-2.6),floor(2.6),<\/li>\n
  5. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0round(-666.588),round(-666.588,2),round(-666.588,-2),<\/li>\n
  6. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0trunc(-666.588),trunc(-666.588,2),trunc(-666.588,-2)<\/li>\n
  7. \u00a0\u00a0\u00a0FROM\u00a0dual<\/li>\n<\/ol>\n

     <\/p>\n

    –\u7ed3\u679c\uff1a<\/p>\n

    ABS(-2.3)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a02.3
    \nCEIL(-2.6)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 -2
    \nCEIL(2.6)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a03
    \nFLOOR(-2.6)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0-3
    \nFLOOR(2.6)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02
    \nROUND(-666.588)\u00a0\u00a0\u00a0\u00a0\u00a0 -667
    \nROUND(-666.588,2)\u00a0\u00a0 -666.59
    \nROUND(-666.588,-2) \u00a0-700
    \nTRUNC(-666.588)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 -666
    \nTRUNC(-666.588,2)\u00a0\u00a0\u00a0 -666.58
    \nTRUNC(-666.588,-2)\u00a0\u00a0 -600<\/p>\n

     <\/p>\n

    sqrt(n)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n(n\u5fc5\u987b\u5927\u4e8e0)\u7684\u5e73\u65b9\u6839<\/p>\n

    power(n,m)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n\u7684m\u6b21\u5e42\uff0c\u5e95\u6570n\u548c\u6307\u6570m\u90fd\u53ef\u4ee5\u662f\u4efb\u610f\u6570\u5b57,\u4f46\u662f\u5982\u679c\u5e95\u6570n\u4e3a\u8d1f\u6570\u5219\u6307\u6570m\u5fc5\u987b\u4e3a\u6b63\u6570<\/p>\n

    exp(n)<\/strong>\uff1a\u8fd4\u56dee(2.71828183….)\u7684n\u6b21\u5e42<\/p>\n

    ln(n)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n(n\u5fc5\u987b\u5927\u4e8e0)\u7684\u81ea\u7136\u5bf9\u6570<\/p>\n

    log(n,m)<\/strong>\uff1a\u8fd4\u56de\u5e95\u6570\u4e3an(\u96640\u53ca1\u7684\u6b63\u6574\u6570)\u7684m(\u4efb\u4f55\u6b63\u6574\u6570)\u5bf9\u6570<\/p>\n

    mod(n,m)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n\/m\u7684\u4f59\u6570,\u5982\u679c\u6570\u5b57m=0\u5219\u8fd4\u56den<\/p>\n

    view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

      \n
    1. –demo\uff1asqrt(),power(),exp(),ln(),log(),mod()<\/li>\n
    2. SELECT\u00a0sqrt(4),power(2,3),exp(1),ln(10),log(2,8),mod(5,2)<\/li>\n
    3. \u00a0\u00a0FROM\u00a0dual<\/li>\n<\/ol>\n

       <\/p>\n

      –\u7ed3\u679c\uff1a<\/p>\n

      SQRT(4)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a02
      \nPOWER(2,3)\u00a0\u00a0\u00a0\u00a0 8
      \nEXP(1)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2.71828182845905
      \nLN(10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a02.30258509299405
      \nLOG(2,8)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3
      \nMOD(5,2)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a01<\/p>\n

       <\/p>\n

      cos(n)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n(\u5f27\u5ea6\u5355\u4f4d\u8868\u793a\u7684\u89d2\u5ea6\u503c)\u7684\u4f59\u5f26\u503c<\/p>\n

      cosh(n)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n\u7684\u53cc\u66f2\u4f59\u5f26\u503c<\/p>\n

      acos(n)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n\u7684\u53cd\u4f59\u5f26\u503c\uff0c\u6c42\u7684\u7ed3\u679c\u5355\u4f4d\u4e3a\u5f27\u5ea6\uff0cn\u7684\u8303\u56f4\u4e3a -1 < n < 1<\/p>\n

      sin(n)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n(\u5f27\u5ea6\u5355\u4f4d\u8868\u793a\u7684\u89d2\u5ea6\u503c)\u7684\u6b63\u5f26\u503c<\/p>\n

      sinh(n,m)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n\u7684\u53cc\u66f2\u6b63\u5f26\u503c<\/p>\n

      asin(n,m)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n\u7684\u53cd\u6b63\u5f26\u503c\uff0c\u6c42\u7684\u7ed3\u679c\u5355\u4f4d\u4e3a\u5f27\u5ea6\uff0cn\u7684\u8303\u56f4\u4e3a -1 < n < 1<\/p>\n

      tan(n)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n(\u5f27\u5ea6\u8868\u793a\u7684\u89d2\u5ea6\u503c)\u7684\u6b63\u5207\u503c<\/p>\n

      tanh(n)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n\u7684\u53cc\u66f2\u6b63\u5207\u503c<\/p>\n

      atan(n)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n\u7684\u53cd\u6b63\u5207\u503c\uff0c\u6c42\u7684\u7ed3\u679c\u5355\u4f4d\u4e3a\u5f27\u5ea6\uff0cn\u7684\u8303\u56f4\u4efb\u610f\u6570\u503c<\/p>\n

      atan(n,m)<\/strong>\uff1a\u8fd4\u56de\u6570\u5b57n\/m\u7684\u53cd\u6b63\u5207\u503c\uff0c\u6c42\u7684\u7ed3\u679c\u5355\u4f4d\u4e3a\u5f27\u5ea6\uff0c\u4f60\u53ef\u4ee5\u4e3a\u4efb\u610f\u6570\u503c\uff0cm\u4e0d\u53ef\u4e3a0<\/p>\n

      view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

        \n
      1. –\u4e09\u89d2\u51fd\u6570\u5e94\u7528demo\uff1a<\/li>\n
      2. SELECT\u00a0cos(0.5),cosh(2),acos(1),<\/li>\n
      3. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0sin(0.5),sinh(2),asin(0),<\/li>\n
      4. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0tan(0.5),tanh(2),atan(8),atan(16\/2)<\/li>\n
      5. \u00a0FROM\u00a0dual<\/li>\n<\/ol>\n

         <\/p>\n

        2\u3001\u5b57\u7b26\u51fd\u6570<\/strong><\/p>\n

        ascii(n)<\/strong>\uff1a\u8fd4\u56de\u5b57\u7b26c\u7684ascii\u503c<\/p>\n

        chr(n)<\/strong>\uff1a\u5c06ascii\u503c\u8f6c\u6362\u4e3a\u5bf9\u5e94\u7684\u5b57\u7b26<\/p>\n

        initcap(s)<\/strong>\uff1a\u5c06\u5b57\u7b26\u4e32s\u6240\u6709\u7684\u5355\u8bcd(\u4f9d\u7a7a\u683c\u6216\u975e\u5b57\u6bcd\u5b57\u7b26\u5212\u5206\u5355\u8bcd\u533a\u95f4)\u7684\u9996\u5b57\u6bcd\u5927\u5199,\u5176\u4f59\u5c0f\u5199<\/p>\n

        lower(s)<\/strong>\uff1a\u5c06\u5b57\u7b26\u4e32s\u4e2d\u6240\u6709\u7684\u5b57\u7b26\u8f6c\u6362\u4e3a\u5c0f\u5199<\/p>\n

        upper(s)<\/strong>\uff1a\u5c06\u5b57\u7b26\u4e32s\u4e2d\u6240\u6709\u7684\u5b57\u7b26\u8f6c\u6362\u4e3a\u5927\u5199<\/p>\n

        concat(s1,s2)<\/strong>\uff1a\u5c06\u5b57\u7b26\u4e32s2\u8fde\u63a5\u5728s1\u540e\u9762\uff0c\u7b49\u540c\u4e8e\u64cd\u4f5c\u7b26||<\/p>\n

        length(s)<\/strong>\uff1a\u5c06\u8fd4\u56de\u5b57\u4e32s\u7684\u957f\u5ea6\uff0c\u8fd4\u56de\u7684\u957f\u5ea6\u5305\u62ec\u5176\u4e2d\u7684\u6240\u6709\u7a7a\u683c(\u5c3e\u90e8\u7a7a\u683c\u4e5f\u7b97)\uff1b\u5982\u679cs\u4e3anull\uff0c\u5219\u8fd4\u56denull<\/p>\n

        view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

          \n
        1. –\u5b57\u7b26\u51fd\u6570demo\uff1a<\/li>\n
        2. SELECT\u00a0ascii(‘A’),chr(65),concat(‘Hello’,’World’),<\/li>\n
        3. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0initcap(‘hello\u00a0woRld’),<\/li>\n
        4. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0lower(‘HeLLo\u00a0woRld’),upper(‘HeLLo\u00a0woRld’),<\/li>\n
        5. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0length(‘HeLLo\u00a0woRld’),length(‘\u674e\u827a\u8f89’)<\/li>\n
        6. \u00a0\u00a0FROM\u00a0dual<\/li>\n<\/ol>\n

          –\u7ed3\u679c\uff1a<\/p>\n

          ASCII(‘A’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 65
          \nCHR(65)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0A
          \nCONCAT(‘HELLO’,’WORLD’) \u00a0HelloWorld
          \nINITCAP(‘HELLOWORLD’)\u00a0\u00a0\u00a0\u00a0 Hello World
          \nLOWER(‘HELLOWORLD’)\u00a0\u00a0\u00a0\u00a0\u00a0 hello world
          \nUPPER(‘HELLOWORLD’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HELLO WORLD
          \nLENGTH(‘HELLOWORLD’)\u00a0\u00a0\u00a0 \u00a011
          \nLENGTH(‘\u674eYI\u8f89’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<\/p>\n

           <\/p>\n

          lpad(s1,n,s2)<\/strong>\uff1a\u5728\u5b57\u4e32s1\u7684\u5de6\u7aef\u586b\u5145\u5b57\u4e32s2\uff0c\u76f4\u81f3\u586b\u5145\u540e\u7684s1\u7684\u603b\u957f\u5ea6\u4e3an<\/p>\n

          \u5982\u679c\u4e0d\u6307\u5b9as2\u5219\u9ed8\u8ba4\u4e3a\u7a7a\u683c<\/p>\n

          \u5982\u679cs1\u7684\u957f\u5ea6>n\uff0c\u5219\u76f4\u63a5\u8fd4\u56des1\u5de6\u7aef\u7684n\u4e2a\u5b57\u7b26<\/p>\n

          rpad(s1,n,s2)<\/strong>\uff1a\u5728\u5b57\u4e32s1\u7684\u53f3\u7aef\u586b\u5145\u5b57\u4e32s2\uff0c\u76f4\u81f3\u586b\u5145\u540e\u7684s1\u7684\u603b\u957f\u5ea6\u4e3an<\/p>\n

          \u5982\u679c\u4e0d\u6307\u5b9as2\u5219\u9ed8\u8ba4\u4e3a\u7a7a\u683c<\/p>\n

          \u5982\u679cs1\u7684\u957f\u5ea6>n\uff0c\u5219\u76f4\u63a5\u8fd4\u56des1\u5de6\u7aef\u7684n\u4e2a\u5b57\u7b26<\/p>\n

          view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

            \n
          1. –lpad\u3001rpad<\/li>\n
          2. SELECT\u00a0lpad(‘a’,10,’8′),lpad(‘LaaaaaaR’,6,’8′),<\/li>\n
          3. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0rpad(‘a’,10,’8′),rpad(‘LaaaaaaR’,6,’8′)<\/li>\n
          4. \u00a0\u00a0FROM\u00a0dual<\/li>\n<\/ol>\n

            –\u7ed3\u679c\uff1a<\/p>\n

            lpad(‘a’,10,’8′)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 888888888a
            \nlpad(‘laaaaaar’,6,’8′)\u00a0\u00a0 \u00a0 laaaaa
            \nrpad(‘a’,10,’8′)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 a888888888
            \nrpad(‘laaaaaar’,6,’8′)\u00a0\u00a0\u00a0 \u00a0laaaaa<\/p>\n

             <\/p>\n

            instr(s1,s2,n,m)<\/strong>\uff1a\u53d6\u5f97\u5b50\u4e32s2\u5728\u5b57\u4e32s1\u4e2d\u7684\u4f4d\u7f6e<\/p>\n

            n\u8868\u793a\u5728s1\u4e2d\u5f00\u59cb\u641c\u7d22\u7684\u4f4d\u7f6e\uff0cm\u8868\u793a\u5b57\u4e32s2\u51fa\u73b0\u7684\u6b21\u6570<\/p>\n

            \u5982\u679cn\u4e3a\u8d1f\u6570\uff0c\u5219\u8868\u793a\u4ece\u5c3e\u90e8\u5f00\u59cb\u641c\u7d22\uff0cn\u4e0em\u9ed8\u8ba4\u4e3a1<\/p>\n

            view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

              \n
            1. SELECT\u00a0instr(‘888terryterry’,’terry’,1,1)\u00a0,instr(‘888terryterry’,’terry’,1,2),<\/li>\n
            2. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0instr(‘888terryterry’,’terry’,-1,1),instr(‘888terryterry’,’terry’,-1,2)<\/li>\n
            3. \u00a0\u00a0FROM\u00a0dual<\/li>\n<\/ol>\n

              –\u7ed3\u679c\uff1a<\/p>\n

              instr(‘888terryterry’,’terry’,1,1)\u00a0\u00a0\u00a0 \u00a04
              \ninstr(‘888terryterry’,’terry’,-1,1)\u00a0\u00a0\u00a0 9
              \ninstr(‘888terryterry’,’terry’,1,2)\u00a0\u00a0\u00a0\u00a0 9
              \ninstr(‘888terryterry’,’terry’,-1,2)\u00a0\u00a0\u00a0 4<\/p>\n

               <\/p>\n

              substr(s1,m,n)<\/strong>\uff1a\u53d6\u5f97\u5b57\u4e32s1\u4ecem\u5f00\u59cb\uff0c\u957f\u5ea6\u4e3an\u7684\u5b50\u4e32\uff0cm>0\u8868\u793a\u4ece\u5934\u5f00\u59cb\u641c\u7d22\uff0cm<0\u8868\u793a\u4ece\u5c3e\u5f00\u59cb<\/p>\n

              view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                \n
              1. SELECT\u00a0substr(‘\u674e\u85dd\u8f1d’,1,2),substr(‘terry’,-4,3)<\/li>\n
              2. \u00a0\u00a0FROM\u00a0dual<\/li>\n<\/ol>\n

                –\u7ed3\u679c\uff1a<\/p>\n

                substr(‘\u674e\u85dd\u8f1d’,1,2)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u674e\u85dd
                \nsubstr(‘terry’,-4,3)\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0err<\/p>\n

                 <\/p>\n

                ltrim(s1,set)<\/strong>\uff1a\u4ece\u5de6\u7aef\u5f00\u59cb\u9010\u4e00\u53d6\u5f97\u5b57\u4e32s1\u5de6\u7aef\u5305\u542b\u7684set\u4e2d\u7684\u4efb\u4f55\u5b57\u7b26<\/p>\n

                \u5f53\u9047\u5230\u4e0d\u662fset\u4e2d\u7684\u5b57\u7b26\u662f\uff0c\u5219\u7ed3\u675f\u5e76\u8fd4\u56de\u5269\u4f59\u7ed3\u679c<\/p>\n

                rtrim(s1,set)<\/strong>\uff1a\u4ece\u53f3\u7aef\u5f00\u59cb\u9010\u4e00\u53d6\u5f97\u5b57\u4e32s1\u53f3\u7aef\u5305\u542b\u7684set\u4e2d\u7684\u4efb\u4f55\u5b57\u7b26<\/p>\n

                \u5f53\u9047\u5230\u4e0d\u662fset\u4e2d\u7684\u5b57\u7b26\u662f\uff0c\u5219\u7ed3\u675f\u5e76\u8fd4\u56de\u5269\u4f59\u7ed3\u679c<\/p>\n

                trim(c FROM s2)<\/strong>\uff1a\u4ece\u5b57\u4e32s2\u7684\u5934\u90e8\u3001\u5c3e\u90e8\u3001\u6216\u4e24\u7aef\u622a\u53bb\u5b57\u7b26c\uff08c\u53ea\u80fd\u591f\u662f\u4e00\u4e2a\u5b57\u7b26\uff09<\/p>\n

                \u5f53\u9047\u5230\u4e0d\u662fset\u4e2d\u7684\u5b57\u7b26\u662f\uff0c\u5219\u7ed3\u675f\u5e76\u8fd4\u56de\u5269\u4f59\u7ed3\u679c<\/p>\n

                view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                  \n
                1. SELECT\u00a0ltrim(‘terry’,’t’),ltrim(‘terry’,’ter’),ltrim(‘terry’,’e’),<\/li>\n
                2. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0rtrim(‘terry’,’y’),rtrim(‘terry’,’ry’),rtrim(‘terry’,’yre’),<\/li>\n
                3. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0trim(‘e’\u00a0from\u00a0‘terry’),trim(‘t’\u00a0from\u00a0‘terry’),trim(‘y’\u00a0from\u00a0‘terryy’)<\/li>\n
                4. \u00a0\u00a0FROM\u00a0dual<\/li>\n<\/ol>\n

                  –\u7ed3\u679c\uff1a<\/p>\n

                  ltrim(‘terry’,’t’)\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 erry
                  \nltrim(‘terry’,’ter’)\u00a0\u00a0\u00a0\u00a0 y
                  \nltrim(‘terry’,’e’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 terry
                  \nrtrim(‘terry’,’y’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 terr
                  \nrtrim(‘terry’,’ry’)\u00a0\u00a0\u00a0\u00a0\u00a0 te
                  \nrtrim(‘terry’,’yre’)\u00a0\u00a0\u00a0 t
                  \ntrim(‘e’from’terry’)\u00a0 terry
                  \ntrim(‘t’from’terry’) \u00a0 erry
                  \ntrim(‘y’from’terryy’)\u00a0terr<\/p>\n

                   <\/p>\n

                  replace(s1,s2,s3)<\/strong>\uff1a\u5c06s1\u5b57\u4e32\u4e2d\u7684\u5b50\u4e32s2\u7528s3\u66ff\u4ee3\uff0c\u5982\u679cs2\u4e3anull\u5219\u8fd4\u56de\u539f\u6765\u7684\u5b57\u4e32s1<\/p>\n

                  \u6ce8\u610f\uff1a\u5982\u679cs3\u4e3anull\uff0c\u5219\u4f1a\u53bb\u6389\u5b50\u4e32s2<\/p>\n

                  view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                    \n
                  1. SELECT\u00a0replace(‘\u674e\u85dd\u8f1d-TERRY’,’\u674e\u85dd\u8f1d’,’\u8af8\u845b\u9322\u597d’),<\/li>\n
                  2. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0replace(‘\u674e\u85dd\u8f1d-TERRY’,’\u674e\u85dd\u8f1d’)<\/li>\n
                  3. \u00a0\u00a0FROM\u00a0dual<\/li>\n<\/ol>\n

                    –\u7ed3\u679c\uff1a<\/p>\n

                    replace(‘\u674e\u85dd\u8f1d-TERRY’,’\u674e\u85dd\u8f1d’,’\u8af8\u845b\u9322\u597d’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u8af8\u845b\u9322\u597d-TERRY
                    \nreplace(‘\u674e\u85dd\u8f1d-TERRY’,’\u674e\u85dd\u8f1d’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 -TERRY<\/p>\n

                     <\/p>\n

                    translate(s1,froms,tos)<\/strong>\uff1a\u5c06\u5b57\u7b26\u4e32s1\u6309\u7167froms\u548ctos\u7684\u5bf9\u5e94\u5173\u7cfb\u8fdb\u884c\u8f6c\u6362<\/p>\n

                    view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                      \n
                    1. SELECT\u00a0translate(‘terry’,’abcdefgxyz’,’8888888666′)<\/li>\n
                    2. \u00a0\u00a0FROM\u00a0dual<\/li>\n<\/ol>\n

                      –\u7ed3\u679c\uff1a<\/p>\n

                      translate(‘terry’,’abcdefgxyz’,’8888888666′)\u00a0\u00a0\u00a0\u00a0 \u00a0t8rr6<\/p>\n

                       <\/p>\n

                      regexp_substr(s1,pattern,position,occurrence,match_parameter)<\/strong>\uff1a<\/p>\n

                      \u6309\u7167\u6b63\u5219\u8868\u8fbe\u5f0fpattern\u4eces1\u5b57\u4e32\u4e2d\u7684position\u4f4d\u7f6e\u5f00\u59cb<\/p>\n

                      \u622a\u53d6\u7b2coccurrence\u6b21\u51fa\u73b0\u7684\u5339\u914dpattern\u7684\u5b57\u4e32\uff0cmatche_parameter\u4e3a\u9ed8\u8ba4\u5339\u914d\u7684\u6587\u672c<\/p>\n

                      position\uff0coccurrence\uff0cmatche_parameter \u9ed8\u8ba4\u4e3a1,1,” ”<\/p>\n

                      regexp_replace(s1,pattern,position,occurrence,match_parameter)<\/strong>\uff1a<\/p>\n

                      \u6b63\u5219\u8868\u8fbe\u5f0f\u6269\u5c55replace\u7684\u529f\u80fd,\u7528\u4e8e\u6309\u7167\u7279\u5b9a\u7684\u8868\u8fbe\u5f0fpattern\u7684\u89c4\u5219\u66ff\u6362\u5b57\u4e32\u4e32s1<\/p>\n

                      s1\u6307\u5b9a\u66ff\u6362\u5b57\u7b26\u4e32\uff0cposition\u6307\u5b9a\u8d77\u59cb\u641c\u7d22\u4f4d\u7f6e<\/p>\n

                      occurrence\u6307\u5b9a\u66ff\u6362\u51fa\u73b0\u7684\u7b2cn\u4e2a\u5b57\u7b26\u4e32<\/p>\n

                      matche_parameter\u6307\u5b9a\u9ed8\u8ba4\u5339\u914d\u64cd\u4f5c\u7684\u6587\u672c\u4e32<\/p>\n

                      regexp_like()<\/strong>\uff1a\u7528\u6b63\u5219\u8868\u8fbe\u5f0f\u6269\u5c55\u540e\u7684like<\/p>\n

                      regexp_instr()<\/strong>\uff1a\u7528\u6b63\u5219\u8868\u8fbe\u5f0f\u6269\u5c55\u540e\u7684instr<\/p>\n

                      view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                        \n
                      1. SELECT\u00a0regexp_substr(‘\u6211\u7684\u90f5\u7bb1yihuiworld@126.com’,'[[:lower:]]{1,}+@{1}+[[:alnum:]]{1,}+\\.{1}+[[:alpha:]]{1,}’),<\/li>\n
                      2. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0regexp_replace(‘\u9019\u500b\u5c4chttp:\/\/www.space.com.tw\/product’,’http:\/\/([[:alnum:]]+\\.?){3,4}+[[:print:]]{1,}’,’www.terry.com’)<\/li>\n
                      3. \u00a0\u00a0FROM\u00a0dual<\/li>\n<\/ol>\n

                        regexp_substr(‘\u6211\u7684\u90f5\u7bb1yihuiworld@126.com’,'[[:lower:]]{1,}+@{1}+[[:alnum:]]{1,}+\\.{1}+[[:alpha:]]{1,}’<\/a>)<\/p>\n

                        –\u7ed3\u679c:\u00a0\u00a0 yihuiworld@126.com<\/a><\/p>\n

                        regexp_replace(‘\u9019\u500b\u5c4chttp:\/\/www.space.com.tw\/product’,’http:\/\/([[:alnum:]]+\\.?){3,4}+[[:print:]]{1,}’,’www.terry.com’<\/a>)<\/p>\n

                        –\u7ed3\u679c\uff1a\u9019\u500b\u5c4cwww.terry.com<\/a><\/p>\n

                         <\/p>\n

                        3\u3001\u65e5\u671f\u51fd\u6570<\/strong><\/p>\n

                        sysdate<\/strong>\uff1a\u8fd4\u56de\u7cfb\u7edf\u5f53\u524d\u65e5\u671f\u65f6\u95f4<\/p>\n

                        systimestamp<\/strong>\uff1a\u8fd4\u56de\u7cfb\u7edf\u5f53\u524d\u65e5\u671f\u65f6\u95f4\u548c\u65f6\u533a<\/p>\n

                        current_date<\/strong>\uff1a\u8fd4\u56de\u5f53\u524d\u56de\u8bdd\u65f6\u533a\u6240\u5bf9\u5e94\u7684\u65e5\u671f\u548c\u65f6\u95f4<\/p>\n

                        current_timestamp<\/strong>\uff1a\u8fd4\u56de\u5f53\u524d\u56de\u8bdd\u65f6\u533a\u6240\u5bf9\u5e94\u7684\u65e5\u671f\u65f6\u95f4<\/p>\n

                        localtimestamp<\/strong>\uff1a\u8fd4\u56de\u5f53\u524d\u56de\u8bdd\u65f6\u533a\u6240\u5bf9\u5e94\u7684\u65e5\u671f\u65f6\u95f4<\/p>\n

                        systimestamp<\/strong>\uff1a\u8fd4\u56de\u7cfb\u7edf\u5f53\u524d\u65e5\u671f\u65f6\u95f4\u548c\u65f6\u533a<\/p>\n

                        sessiontimezone<\/strong>\uff1a\u8fd4\u56de\u5f53\u524d\u56de\u8bdd\u6240\u5728\u7684\u65f6\u533a<\/p>\n

                        dbtimezone<\/strong>\uff1a\u8fd4\u56de\u8d44\u6599\u5e93\u6240\u5728\u7684\u65f6\u533a<\/p>\n

                        view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                          \n
                        1. SELECT\u00a0sysdate,systimestamp,current_date,current_timestamp,<\/li>\n
                        2. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0localtimestamp,sessiontimezone,dbtimezone<\/li>\n
                        3. \u00a0\u00a0FROM\u00a0dual<\/li>\n<\/ol>\n

                          –\u7ed3\u679c\uff1a<\/p>\n

                          SYSDATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2015\/3\/25 13:29:38
                          \nSYSTIMESTAMP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 25-3\u6708 -15 01.29.38.867634 \u4e0b\u5348 +08:00
                          \nCURRENT_DATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2015\/3\/25 13:29:38
                          \nCURRENT_TIMESTAMP\u00a0\u00a0\u00a0\u00a0\u00a0 25-3\u6708 -15 01.29.38.867641 \u4e0b\u5348 +08:00
                          \nLOCALTIMESTAMP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 25-3\u6708 -15 01.29.38.867641 \u4e0b\u5348
                          \nSESSIONTIMEZONE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 +08:00
                          \nDBTIMEZONE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 +08:00<\/p>\n

                           <\/p>\n

                          add_months(d,n)<\/strong>\uff1a\u8fd4\u56de\u6307\u5b9a\u65e5\u671fd\u4e4b\u540e(\u6216\u524d)\u7684n\u500b\u6708\u6240\u5c0d\u61c9\u7684\u65e5\u671f\u6642\u9593;n>0\uff1a\u4e4b\u540e\uff0cn<0\uff1a\u4e4b\u524d<\/p>\n

                          extract()<\/strong>\uff1a\u7528\u65bc\u5f9e\u7279\u5b9a\u7684\u65e5\u671f\u6642\u9593\u503c\u91cc\u53d6\u51fa\u6240\u9700\u8981\u7684\u7279\u5b9a\u6578\u64da(\u5982\u65e5\u671f\u3001\u6708\u4efd\u3001\u65e5\u3001\u6642\u9593\u7b49)<\/p>\n

                          last_day(d)\uff1a<\/strong>\u7528\u65bc\u8fd4\u56de\u6307\u5b9a\u65e5\u671f\u6240\u5728\u6708\u4efd\u7684\u6700\u5f8c\u4e00\u5929<\/p>\n

                          next_day(d,char)\uff1a<\/strong>\u8fd4\u56de\u6307\u5b9a\u65e5\u671f\u540e\u7684\u4e00\u500b\u5de5\u4f5c\u65e5(\u7531char\u6307\u5b9a)\u6240\u5c0d\u61c9\u7684\u65e5\u524d<\/p>\n

                          round(d[,fmt])\uff1a<\/strong>\u8fd4\u56de\u65e5\u671f\u6642\u9593\u7684\u56db\u820d\u4e94\u5982\u7d50\u679c\uff0c\u5982\u679cfmt\u6307\u5b9a\u5e74\u5ea6\u52477\u67081\u65e5\u70ba\u5206\u754c\u7dda
                          \n\u5982\u679cfmt\u6307\u5b9a\u6708\u524716\u65e5\u70ba\u5206\u754c\u7dda\uff0c\u5982\u679cfmt\u6307\u5b9a\u5929\u5247\u4e2d\u534812:00\u70ba\u5206\u754c\u7dda<\/p>\n

                          trunc(d[,fmt])\uff1a<\/strong>\u7528\u65bc\u622a\u65b7\u65e5\u671f\u6642\u9593\u6578\u64da\uff0c\u5982\u679cfmt\u6307\u5b9a\u5e74\u5ea6\u5247\u7d50\u679c\u70ba\u672c\u5e74\u76841\u67081\u65e5
                          \n\u5982\u679cfmt\u6307\u5b9a\u6708\u5247\u7d50\u679c\u70ba\u672c\u67081\u65e5\uff0c\u5982\u679cfmt\u7a7a\u5247\u7d50\u679c\u70ba\u622a\u53d6\u65e5\u671f\u6642\u9593\u6578\u64da\u4e2d\u7684\u65e5\u671f<\/p>\n

                          view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                            \n
                          1. SELECT\u00a0sysdate,add_months(sysdate,4),add_months(sysdate,-4),<\/li>\n
                          2. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0extract(MONTH\u00a0from\u00a0sysdate),last_day(sysdate),next_day(sysdate,’\u661f\u671f\u4e00’),<\/li>\n
                          3. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0round(sysdate,’YEAR’),round(sysdate,’MONTH’),round(sysdate,’DAY’),round(sysdate),<\/li>\n
                          4. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0trunc(sysdate,’YEAR’),trunc(sysdate,’MONTH’),trunc(sysdate,’DAY’),trunc(sysdate)<\/li>\n
                          5. \u00a0\u00a0FROM\u00a0dual<\/li>\n<\/ol>\n

                            –\u7ed3\u679c\uff1a<\/p>\n

                            SYSDATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a02015\/3\/25 13:40:14
                            \nADD_MONTHS(SYSDATE,4)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02015\/7\/25 13:40:14
                            \nADD_MONTHS(SYSDATE,-4)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2014\/11\/25 13:40:14
                            \nEXTRACT(MONTHFROMSYSDATE)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3
                            \nLAST_DAY(SYSDATE)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2015\/3\/31 13:40:14
                            \nNEXT_DAY(SYSDATE,’\u661f\u671f\u4e00’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2015\/3\/30 13:40:14
                            \nROUND(SYSDATE,’YEAR’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02015\/1\/1
                            \nROUND(SYSDATE,’MONTH’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2015\/4\/1
                            \nROUND(SYSDATE,’DAY’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2015\/3\/29
                            \nROUND(SYSDATE)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02015\/3\/26
                            \nTRUNC(SYSDATE,’YEAR’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2015\/1\/1
                            \nTRUNC(SYSDATE,’MONTH’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2015\/3\/1
                            \nTRUNC(SYSDATE,’DAY’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2015\/3\/22
                            \nTRUNC(SYSDATE)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2015\/3\/25<\/p>\n

                             <\/p>\n

                            to_timestamp(chr[fmt[,nls_param]])<\/strong>\uff1a\u5c07\u7b26\u5408\u7279\u5b9a\u65e5\u671f\u548c\u6642\u9593\u6309\u683c\u5f0f\u7684\u5b57\u7b26\u4e32\u8f49\u8b8a\u70baTIMESTAMP\u985e\u578b<\/p>\n

                            view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                              \n
                            1. –\u67e5\u8a62\u00a02015-03-25\u00a011:30:00\u00a0\u6642\u9593\u9ede\u6642\u00a0oay_file\u00a0\u8a18\u9304\u00a0[\u65f6\u95f4\u6413\u4e0d\u80fd>\u5f53\u524d\u65f6\u95f4\u70b9\u00a0\u4e14\u00a0\u4e0d\u80fd\u592a\u65e9]<\/li>\n
                            2. select\u00a0*\u00a0from\u00a0oay_file\u00a0as\u00a0of\u00a0timestamp\u00a0to_timestamp(‘2015-03-25\u00a011:30:00′,’YYYY-MM-DD\u00a0HH24:MI:SS’)<\/li>\n<\/ol>\n

                               <\/p>\n

                              month_between(d1,d2)<\/strong>\uff1a\u8fd4\u56de\u65e5\u671fd1\u8207d2\u4e4b\u9593\u76f8\u5dee\u7684\u6708\u4efd\u6578<\/p>\n

                              \u5982\u679cd1<d2\u5247\u8fd4\u56de\u8ca0\u6578\uff0c\u5982\u679cd1\u548cd2\u7684\u5929\u6578\u76f8\u540c\u6216\u90fd\u662f\u6708\u5e95\u5247\u8fd4\u56de\u6574\u6578,\u5426\u5247oracle\u4ee5\u6bcf\u670831\u5929\u70ba\u6e96\u4f86\u8a08\u7b97\u7d50\u679c\u7684\u5c0f\u6578\u90e8\u4efd<\/p>\n

                              view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                \n
                              1. select\u00a0sysdate,months_between(sysdate,to_date(‘2012\/06\/30′,’YYYY\/MM\/DD’))<\/li>\n
                              2. \u00a0\u00a0from\u00a0dual<\/li>\n<\/ol>\n

                                –\u7ed3\u679c\uff1a<\/p>\n

                                SYSDATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a02015\/3\/25 13:49:40
                                \nMONTHS_BETWEEN(SYSDATE,TO_DATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 32.8572954002389<\/p>\n

                                 <\/p>\n

                                4\u3001\u6570\u636e\u5e93\u7cfb\u7edf\u76f8\u5173\u914d\u7f6e<\/strong><\/p>\n

                                sys_context(context,attribute)<\/strong>\uff1a\u8fd4\u56de\u61c9\u7528\u4e0a\u4e0b\u6587\u7279\u5b9a\u5c6c\u6027\uff0c\u5176\u4e2dcontext\u6307\u5b9a\u61c9\u7528\u4e0a\u4e0b\u6587\u540d\uff0cattribute\u6307\u5b9a\u5c0d\u61c9\u7684\u5c6c\u6027<\/p>\n

                                view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                  \n
                                1. select\u00a0SYS_CONTEXT(‘USERENV’,’TERMINAL’)\u00a0terminal,<\/li>\n
                                2. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’LANGUAGE’)\u00a0language,<\/li>\n
                                3. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’SESSIONID’)\u00a0sessionid,<\/li>\n
                                4. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’INSTANCE’)\u00a0instance,<\/li>\n
                                5. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’ENTRYID’)\u00a0entryid,<\/li>\n
                                6. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’ISDBA’)\u00a0isdba,<\/li>\n
                                7. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’NLS_TERRITORY’)\u00a0nls_territory,<\/li>\n
                                8. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’NLS_CURRENCY’)\u00a0nls_currency,<\/li>\n
                                9. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’NLS_CALENDAR’)\u00a0nls_calendar,<\/li>\n
                                10. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’NLS_DATE_FORMAT’)\u00a0nls_date_format,<\/li>\n
                                11. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’NLS_DATE_LANGUAGE’)\u00a0nls_date_language,<\/li>\n
                                12. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’NLS_SORT’)\u00a0nls_sort,<\/li>\n
                                13. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’CURRENT_USER’)\u00a0current_user,<\/li>\n
                                14. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’CURRENT_USERID’)\u00a0current_userid,<\/li>\n
                                15. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’SESSION_USER’)\u00a0session_user,<\/li>\n
                                16. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’SESSION_USERID’)\u00a0session_userid,<\/li>\n
                                17. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’PROXY_USER’)\u00a0proxy_user,<\/li>\n
                                18. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’PROXY_USERID’)\u00a0proxy_userid,<\/li>\n
                                19. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’DB_DOMAIN’)\u00a0db_domain,<\/li>\n
                                20. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’DB_NAME’)\u00a0db_name,<\/li>\n
                                21. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’HOST’)\u00a0host,<\/li>\n
                                22. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’OS_USER’)\u00a0os_user,<\/li>\n
                                23. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’EXTERNAL_NAME’)\u00a0external_name,<\/li>\n
                                24. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’IP_ADDRESS’)\u00a0ip_address,<\/li>\n
                                25. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’NETWORK_PROTOCOL’)\u00a0network_protocol,<\/li>\n
                                26. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’BG_JOB_ID’)\u00a0bg_job_id,<\/li>\n
                                27. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’FG_JOB_ID’)\u00a0fg_job_id,<\/li>\n
                                28. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’AUTHENTICATION_TYPE’)\u00a0authentication_type,<\/li>\n
                                29. \u00a0\u00a0\u00a0SYS_CONTEXT(‘USERENV’,’AUTHENTICATION_DATA’)\u00a0authentication_data<\/li>\n
                                30. \u00a0from\u00a0dual<\/li>\n<\/ol>\n

                                  –\u7ed3\u679c\uff1a<\/p>\n

                                  TERMINAL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PCS13098
                                  \nLANGUAGE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SIMPLIFIED CHINESE_CHINA.AL32UTF8
                                  \nSESSIONID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 26273213
                                  \nINSTANCE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a01
                                  \nENTRYID
                                  \nISDBA\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FALSE
                                  \nNLS_TERRITORY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0CHINA
                                  \nNLS_CURRENCY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0RMB
                                  \nNLS_CALENDAR\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 GREGORIAN
                                  \nNLS_DATE_FORMAT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DD-MON-RR
                                  \nNLS_DATE_LANGUAGE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SIMPLIFIED CHINESE
                                  \nNLS_SORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 BINARY
                                  \nCURRENT_USER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0SZPF
                                  \nCURRENT_USERID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a055
                                  \nSESSION_USER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0SZPF
                                  \nSESSION_USERID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 55
                                  \nPROXY_USER
                                  \nPROXY_USERID
                                  \nDB_DOMAIN
                                  \nDB_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0topprod
                                  \nHOST\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DOMAIN\\PCS13098
                                  \nOS_USER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 terrylee
                                  \nEXTERNAL_NAME
                                  \nIP_ADDRESS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0192.168.5.227
                                  \nNETWORK_PROTOCOL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0tcp
                                  \nBG_JOB_ID
                                  \nFG_JOB_ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0
                                  \nAUTHENTICATION_TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DATABASE
                                  \nAUTHENTICATION_DATA<\/p>\n

                                   <\/p>\n

                                  UID<\/strong>\uff1a\u8fd4\u56de\u7576\u524d\u6703\u8a71\u7528\u6236\u7684ID\u865f
                                  \nUSER<\/strong>\uff1a\u8fd4\u56de\u7576\u524d\u6703\u8a71\u6240\u5c0d\u61c9\u8cc7\u6599\u5eab\u7528\u6236\u540d
                                  \nUSERENV(parameter)<\/strong>\uff1a\u8fd4\u56de\u7576\u524d\u6703\u8a71\u4e0a\u4e0b\u6587\u7684\u5c6c\u6027\u4fe1\u606f
                                  \n\u5176\u4e2dparameter\u53ef\u53d6\u503c:ISDBA\u3001LANGUAGE\u3001TERMINAL\u3001CLIENT_INFO<\/p>\n

                                  view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                    \n
                                  1. select\u00a0uid,user,userenv(‘ISDBA’)\u00a0from\u00a0dual<\/li>\n<\/ol>\n

                                    –\u7ed3\u679c\uff1a<\/p>\n

                                    UID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 55
                                    \nUSER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SZPF
                                    \nUSERENV(‘ISDBA’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FALSE<\/p>\n

                                     <\/p>\n

                                    sys_guid()<\/strong>\uff1a\u7528\u65bc\u751f\u6210\u985e\u578b\u70baRAW\u768416\u5b57\u7bc0\u7684\u552f\u4e00\u6a19\u8b58\u7b26,\u6bcf\u6b21\u8abf\u7528\u8a72\u51fd\u6578\u90fd\u6703\u751f\u6210\u4e0d\u540c\u7684RAW\u6578\u64da<\/p>\n

                                    view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                      \n
                                    1. select\u00a0sys_guid(),sys_guid()\u00a0from\u00a0dual<\/li>\n<\/ol>\n

                                      –\u7ed3\u679c\uff1a<\/p>\n

                                      SYS_GUID()\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1217A841ED2B6437E0530900A8C0B6F8
                                      \nSYS_GUID()\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1217A841ED2C6437E0530900A8C0B6F8<\/p>\n

                                       <\/p>\n

                                      5\u3001\u590d\u6742\u5355\u884c\u51fd\u6570<\/strong><\/p>\n

                                      coalesce(expr1[,expr2]…)<\/strong>\uff1a\u8fd4\u56de\u904b\u7b97\u5f0f\u4e2d\u7b2c\u4e00\u500bnot null\u904b\u7b97\u5f0f\u7684\u7d50\u679c<\/p>\n

                                      decode(expr,search1,result[,search2,result2,..][,default])<\/strong>\uff1a\u8fd4\u56de\u5339\u914d\u4e8e\u7279\u5b9a\u904b\u7b97\u5f0f\u7684\u7d50\u679c<\/p>\n

                                      \u5982\u679csearch1\u5339\u914dexpr\u5247\u8fd4\u56deresult1\uff0c\u5982\u679c\u5982\u679csearch2\u5339\u914dexpr\u5247\u8fd4\u56deresult2
                                      \n\u4f9d\u6b21\u985e\u63a8\uff0c\u5982\u679c\u6c92\u6709\u4efb\u4f55\u5339\u914d\u95dc\u4fc2\u5247\u8fd4\u56dedefault<\/p>\n

                                      view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                        \n
                                      1. select\u00a0coalesce(”,”,’terry’,’zhanna’),<\/li>\n
                                      2. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0decode(‘M’,’W’,’girl’,’M’,’boy’,’person’)<\/li>\n
                                      3. <\/li>\n
                                      4. \u00a0\u00a0from\u00a0dual<\/li>\n<\/ol>\n

                                        –\u7ed3\u679c\uff1a<\/p>\n

                                        coalesce(”,”,’terry’,’zhanna’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 terry
                                        \ndecode(‘M’,’W’,’girl’,’M’,’boy’,’person’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0boy<\/p>\n

                                         <\/p>\n

                                        greatest(expr1[,expr2]…)\uff1a<\/strong>\u8fd4\u56de\u5217\u8868\u904b\u7b97\u5f0fexpr1,expr2,…\u4e2d\u503c\u6700\u5927\u7684\u4e00\u500b
                                        \n\u5728\u6bd4\u8f03\u4e4b\u524d\uff0cexpr2\u7b49\u9805\u6703\u88ab\u96b1\u542b\u5730\u8f49\u63db\u70baexpr1\u7684\u6642\u5019\u64da\u985e\u578b<\/p>\n

                                        least(expr1[,expr2]…)\uff1a<\/strong>\u8fd4\u56de\u5217\u8868\u904b\u7b97\u5f0fexpr1,expr2,…\u4e2d\u503c\u6700\u5c0f\u7684\u4e00\u500b
                                        \n\u5728\u6bd4\u8f03\u4e4b\u524d\uff0cexpr2\u7b49\u9805\u6703\u88ab\u96b1\u542b\u5730\u8f49\u63db\u70baexpr1\u7684\u6642\u5019\u64da\u985e\u578b<\/p>\n

                                        nullif(expr1,expr2)\uff1a<\/strong>\u6bd4\u8f03expr1\u548cexpr2\uff0c\u5982\u679c\u4e8c\u8005\u76f8\u7b49\u5247\u8fd4\u56denull\uff0c\u5426\u5247\u8fd4\u56deexpr1<\/p>\n

                                        view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                          \n
                                        1. select\u00a0greatest(‘terry’,’888′,’zhanna’,’666′),<\/li>\n
                                        2. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0least(‘terry’,’888′,’zhanna’,’666′),<\/li>\n
                                        3. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0nullif(‘terry’,’zhanna’),nullif(‘1′,’1’)<\/li>\n
                                        4. \u00a0\u00a0from\u00a0dual<\/li>\n<\/ol>\n

                                          –\u7ed3\u679c\uff1a<\/p>\n\n\n\n\n
                                          greatest(‘terry’,’888′,’zhanna’,’666′)<\/td>\nzhanna<\/td>\nnullif(‘terry’,’zhanna’)<\/td>\nterry<\/td>\n<\/tr>\n
                                          least(‘terry’,’888′,’zhanna’,’666′)<\/td>\n666<\/td>\nnullif(‘1′,’1’)<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                                           <\/p>\n

                                          sys_connect_by_path(column,char)\uff1a<\/strong>\u7528\u65bc\u8fd4\u56de\u5f9e\u6839\u5230\u5b50\u7bc0\u9ede\u7684\u5217\u503c\u8def\u9032\uff0c\u503c\u9069\u7528\u4e8e\u5c64\u6b21\u67e5\u8a62<\/p>\n

                                          view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                            \n
                                          1. –\u5c55\u6210\u54c1\u6599\u865fTE902C\u00a0BOM\u4e0b\u968e\u5143\u4ef6<\/li>\n
                                          2. select\u00a0lpad(‘\u00a0‘,2*level-1)||sys_connect_by_path(bmb03,’|–‘)\u00a0“TE902C\u5c55BOM\u5143\u4ef6”<\/li>\n
                                          3. \u00a0\u00a0from\u00a0bmb_file<\/li>\n
                                          4. \u00a0\u00a0start\u00a0with\u00a0bmb01\u00a0=\u00a0‘TE902C’<\/li>\n
                                          5. \u00a0\u00a0connect\u00a0by\u00a0prior\u00a0bmb03\u00a0=\u00a0bmb01<\/li>\n<\/ol>\n

                                            –\u7ed3\u679c\uff1a<\/p>\n

                                            |–1300-00677002
                                            \n|–1300-00677002|–3230-00677000
                                            \n|–1300-00677002|–5410-TE902C02
                                            \n|–1300-00677002|–LPLA10002
                                            \n|–1300-00677002|–LPLA10002|–1800-00100117
                                            \n|–1300-00677002|–LPLA10002|–1800-00100117|–2101-01002000
                                            \n|–1300-00677002|–LPLA10002|–1800-00100117|–2101-02001034
                                            \n|–1300-00677002|–LPLA10002|–1800-00100118
                                            \n|–1300-00677002|–LPLA10002|–1800-00100118|–2102-02003001
                                            \n|–1300-00677002|–LPLA10002|–1800-00100118|–2230-05005000
                                            \n|–1300-00677002|–LPLA10002|–1800-00200300
                                            \n|–1300-00677002|–LPLA10002|–1800-00200300|–2101-04012016
                                            \n|–1300-00677002|–LPLA10002|–1800-00200300|–2102-02003001
                                            \n|–1300-00677002|–LPLA10002|–1800-00200311
                                            \n|–1300-00677002|–LPLA10002|–1800-00200311|–2101-04012016
                                            \n|–1300-00677002|–LPLA10002|–1800-00200325
                                            \n|–1300-00677002|–LPLA10002|–1800-00200325|–2101-04012016
                                            \n|–1300-00677002|–LPLA10002|–1800-00200325|–2230-02002001
                                            \n|–1300-00677002|–LPLA10002|–1800-00200409
                                            \n|–1300-00677002|–LPLA10002|–1800-00200409|–2101-04012016
                                            \n|–1300-00677002|–LPLA10002|–1800-00200409|–2230-02002001
                                            \n|–1300-00677002|–LPLA10002|–2101-02001035
                                            \n|–4410-TE902C00
                                            \n|–6110-11001000<\/p>\n

                                             <\/p>\n

                                            6\u3001\u5206\u6790\u805a\u5408\u51fd\u6570<\/strong><\/p>\n

                                            rank(expr1,expr2,…) within group(order by col1,col2,…)\uff1a<\/strong>\u8fd4\u56de\u7279\u5b9a\u6578\u503c\u5728\u7d71\u8a08\u6578\u503c\u4e2d\u6240\u4f54\u64da\u7684\u7b49\u7d1a,expr1,expr2,…\u5fc5\u9808\u70ba\u5e38\u6578
                                            \ndense_rank(expr1,expr2,…) within group(order by expr1,expr2,…)\uff1a<\/strong>\u8fd4\u56de\u7279\u5b9a\u6578\u503c\u5728\u4e00\u7d44\u884c\u6578\u64da\u4e2d\u7684\u7b49\u7d1a
                                            \npercent_rank(expr1,expr2,…) within group(order by expr1,expr2,…)\uff1a<\/strong>\u8fd4\u56de\u7279\u5b9a\u6578\u503c\u5728\u7d71\u8a08\u6578\u503c\u5728\u7d71\u8a08\u7d1a\u5225\u4e2d\u6240\u5360\u7684\u6bd4\u4f8b<\/p>\n

                                            view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                              \n
                                            1. select\u00a0rank(1530.100000)\u00a0within\u00a0group(order\u00a0by\u00a0apa31)\u00a0rank_level,<\/li>\n
                                            2. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0dense_rank(1530.100000)\u00a0within\u00a0group(order\u00a0by\u00a0apa31)\u00a0dense_rank_level,<\/li>\n
                                            3. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0percent_rank(1530.100000)\u00a0within\u00a0group(order\u00a0by\u00a0apa31)\u00a0percent_quto<\/li>\n
                                            4. \u00a0\u00a0from\u00a0ds.apa_file<\/li>\n<\/ol>\n

                                              –\u7ed3\u679c\uff1a<\/p>\n

                                              RANK_LEVEL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0DENSE_RANK_LEVEL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0PERCENT_QUTO
                                              \n2254\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a01159\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a00.312136326<\/p>\n

                                               <\/p>\n

                                              percentile_cont(percent_expr)within group(order by expr)\uff1a<\/strong>\u8fd4\u56de\u5728\u8a08\u7d1a\u5225\u4e2d\u8655\u65bc\u67d0\u500b\u767e\u5206\u9ede\u7684\u7279\u5b9a\u6578\u503c(\u6309\u7167\u9023\u7e8c\u5206\u4f48\u6a21\u578b\u78ba\u5b9a)
                                              \npercentile_disc(percent_expr)within group(order by expr)\uff1a<\/strong>\u8fd4\u56de\u5728\u8a08\u7d1a\u5225\u4e2d\u8655\u65bc\u67d0\u500b\u767e\u5206\u9ede\u7684\u7279\u5b9a\u6578\u503c(\u6309\u7167\u96e2\u6563\u5206\u4f48\u6a21\u578b\u78ba\u5b9a)<\/p>\n

                                              first<\/strong>\uff1a\u53d6\u5f97\u6392\u5e8f\u7b49\u7d1a\u7684\u7b2c\u4e00\u7d1a\uff0c\u7136\u5f8c\u4f7f\u7528\u5206\u7d44\u51fd\u6578\u532f\u7e3d\u8a72\u7b49\u7d1a\u7684\u6578\u64da,\u8a72\u51fd\u6578\u4e0d\u80fd\u5920\u55ae\u7368\u4f7f\u7528\uff0c\u5fc5\u9808\u8207\u5176\u5b83\u5206\u7d44\u51fd\u6578\u7d50\u5408\u4f7f\u7528
                                              \nlast<\/strong>\uff1a\u53d6\u5f97\u6392\u5e8f\u7b49\u7d1a\u7684\u6700\u5f8c\u4e00\u7d1a\uff0c\u7136\u5f8c\u4f7f\u7528\u5206\u7d44\u51fd\u6578\u532f\u7e3d\u8a72\u7b49\u7d1a\u7684\u6578\u64da,\u8a72\u51fd\u6578\u4e0d\u80fd\u5920\u55ae\u7368\u4f7f\u7528\uff0c\u5fc5\u9808\u8207\u5176\u5b83\u5206\u7d44\u51fd\u6578\u7d50\u5408\u4f7f\u7528<\/p>\n

                                              view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                                \n
                                              1. select\u00a0min(apa35)\u00a0keep\u00a0(dense_rank\u00a0first\u00a0order\u00a0by\u00a0apa31\u00a0desc)\u00a0“AP\u91d1\u984d\u6700\u591a\u7b49\u7d1a\u4e2d\u7684\u6700\u5c0f\u5df2\u4ed8”,<\/li>\n
                                              2. <\/li>\n
                                              3. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0max(apa35)\u00a0keep\u00a0(dense_rank\u00a0first\u00a0order\u00a0by\u00a0apa31\u00a0desc)\u00a0“AP\u91d1\u984d\u6700\u591a\u7b49\u7d1a\u4e2d\u7684\u6700\u5927\u5df2\u4ed8”<\/li>\n
                                              4. <\/li>\n
                                              5. \u00a0\u00a0from\u00a0ds.apa_file<\/li>\n<\/ol>\n

                                                –\u7ed3\u679c\uff1a<\/p>\n

                                                AP\u91d1\u984d\u6700\u591a\u7b49\u7d1a\u4e2d\u7684\u6700\u5c0f\u5df2\u4ed8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AP\u91d1\u984d\u6700\u591a\u7b49\u7d1a\u4e2d\u7684\u6700\u5927\u5df2\u4ed8
                                                \n3500000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3500000<\/p>\n

                                                 <\/p>\n

                                                over()<\/strong>\u8996\u7a97\u51fd\u6578
                                                \nover ([partition by col1] order by col2) )<\/strong> \u8868\u793a\u4f9dcol1\u5206\u7d44,\u4f9dcol2\u5728\u5206\u7d44\u985e\u6392\u5e8f
                                                \nover\u51fd\u6578\u4e0d\u80fd\u5920\u55ae\u7368\u4f7f\u7528\uff0c\u5fc5\u9808\u548c\u5176\u5b83\u7684\u5206\u7d44\/\u5206\u6790\u51fd\u6578\u914d\u5408\u4f7f\u7528
                                                \nover\u51fd\u6578\u4e0d\u53ef\u7528\u5728where\u5b50\u53e5\u4e2d<\/p>\n

                                                view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                                  \n
                                                1. –\u7d71\u8a082G88\u82072G60\u90e8\u95802012-04\u6708\u85aa\u8cc7\u5206\u914d<\/li>\n
                                                2. select\u00a0cqk09\u00a0\u59d3\u540d,cqk05\u00a0\u90e8\u9580,cqk30\u00a0\u85aa\u6c34,<\/li>\n
                                                3. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0sum(cqk30)\u00a0over(partition\u00a0by\u00a0cqk05\u00a0order\u00a0by\u00a0cqk09)\u00a0\u90e8\u9580\u85aa\u6c34\u9023\u7e8c\u52a0\u7e3d,<\/li>\n
                                                4. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0sum(cqk30)\u00a0over(partition\u00a0by\u00a0cqk05)\u00a0\u90e8\u9580\u85aa\u6c34\u7e3d\u8a08,<\/li>\n
                                                5. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0100*(round(cqk30\/sum(cqk30)\u00a0over(partition\u00a0by\u00a0cqk05),5))\u00a0“\u500b\u4eba\u85aa\u6c34\u5360\u90e8\u9580\u4efd\u984d%”,<\/li>\n
                                                6. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0sum(cqk30)\u00a0over(order\u00a0by\u00a0cqk05,cqk09)\u00a0\u6240\u6709\u85aa\u6c34\u9023\u7e8c\u52a0\u7e3d,<\/li>\n
                                                7. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0sum(cqk30)\u00a0over()\u00a0\u6240\u6709\u85aa\u6c34\u7e3d\u8a08,<\/li>\n
                                                8. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0100*(round(cqk30\/sum(cqk30)\u00a0over(),5))\u00a0“\u500b\u4eba\u85aa\u6c34\u5360\u7e3d\u548c\u4efd\u984d%”<\/li>\n
                                                9. \u00a0\u00a0from\u00a0cqk_file<\/li>\n
                                                10. \u00a0\u00a0where\u00a0cqk03=2012\u00a0and\u00a0cqk031\u00a0=\u00a04\u00a0and\u00a0cqk05\u00a0in\u00a0(‘2G88′,’2G60’)<\/li>\n<\/ol>\n

                                                  –\u7ed3\u679c\uff1a<\/p>\n\n\n\n\n\n\n\n\n\n\n
                                                  \u59d3\u540d<\/td>\n\u90e8\u9580<\/td>\n\u85aa\u6c34<\/td>\n\u90e8\u9580\u85aa\u6c34\u9023\u7e8c\u52a0\u7e3d<\/td>\n\u90e8\u9580\u85aa\u6c34\u7e3d\u8a08<\/td>\n\u500b\u4eba\u85aa\u6c34\u5360\u90e8\u9580\u4efd\u984d%<\/td>\n\u6240\u6709\u85aa\u6c34\u9023\u7e8c\u52a0\u7e3d<\/td>\n\u6240\u6709\u85aa\u6c34\u7e3d\u8a08<\/td>\n\u500b\u4eba\u85aa\u6c34\u5360\u7e3d\u548c\u4efd\u984d%<\/td>\n<\/tr>\n
                                                  AX<\/td>\n2G60<\/td>\n33086<\/td>\n33086<\/td>\n138382<\/td>\n23.909<\/td>\n33086<\/td>\n335666<\/td>\n9.857<\/td>\n<\/tr>\n
                                                  BX<\/td>\n2G60<\/td>\n77884<\/td>\n110970<\/td>\n138382<\/td>\n56.282<\/td>\n110970<\/td>\n335666<\/td>\n23.203<\/td>\n<\/tr>\n
                                                  CX<\/td>\n2G60<\/td>\n27412<\/td>\n138382<\/td>\n138382<\/td>\n19.809<\/td>\n138382<\/td>\n335666<\/td>\n8.166<\/td>\n<\/tr>\n
                                                  DX<\/td>\n2G88<\/td>\n56273<\/td>\n56273<\/td>\n197284<\/td>\n28.524<\/td>\n194655<\/td>\n335666<\/td>\n16.765<\/td>\n<\/tr>\n
                                                  SS<\/td>\n2G88<\/td>\n70994<\/td>\n127267<\/td>\n197284<\/td>\n35.986<\/td>\n265649<\/td>\n335666<\/td>\n21.15<\/td>\n<\/tr>\n
                                                  IP<\/td>\n2G88<\/td>\n39187<\/td>\n166454<\/td>\n197284<\/td>\n19.863<\/td>\n304836<\/td>\n335666<\/td>\n11.674<\/td>\n<\/tr>\n
                                                  DS<\/td>\n2G88<\/td>\n30830<\/td>\n197284<\/td>\n197284<\/td>\n15.627<\/td>\n335666<\/td>\n335666<\/td>\n9.185<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                                                   <\/p>\n

                                                  view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                                    \n
                                                  1. –row_number()\u7d50\u5408over\u6392\u5e8f\u7d71\u8a082012-04\u85aa\u8cc7\u6c34\u5e73\u4e2d\u5404\u90e8\u9580\u6700\u9ad8\u76842\u4f4d<\/li>\n
                                                  2. \u00a0\u00a0—\u00a0select\u00a0cqk09\u00a0\u59d3\u540d,cqk05\u00a0\u90e8\u9580,cqk30\u00a0\u85aa\u6c34,<\/li>\n
                                                  3. \u00a0\u00a0—\u00a0\u00a0row_number()\u00a0over(partition\u00a0by\u00a0cqk05\u00a0order\u00a0by\u00a0cqk30\u00a0desc)\u00a0as\u00a0salary_order<\/li>\n
                                                  4. \u00a0\u00a0—\u00a0\u00a0from\u00a0cqk_file<\/li>\n
                                                  5. \u00a0\u00a0—\u00a0\u00a0where\u00a0cqk03=2012\u00a0and\u00a0cqk031\u00a0=\u00a04\u00a0and\u00a0salary_order<=2\u00a0–\u6b64\u8655\u7121\u6cd5\u5f15\u7528salary_order,\u76f4\u63a5\u7528over\u904b\u7b97\u5f0f\u4e5f\u662f\u932f\u8aa4\u7684<\/li>\n
                                                  6. \u00a0\u00a0—\u00a0\u4e0a\u8ff0SQL\u6bb5\u662f\u932f\u8aa4\u7684over\u67e5\u8a62\u51fa\u4f86\u4f9d\u5225\u540d\u505a\u5217\u4e5f\u4e0d\u53ef\u4ee5\u4e8ewhere\u5b50\u53e5\u4e2d\u4f7f\u7528<\/li>\n
                                                  7. \u00a0\u00a0select\u00a0cqk09\u00a0\u59d3\u540d,cqk05\u00a0\u90e8\u9580,cqk30\u00a0\u85aa\u6c34,salary_order\u00a0\u6392\u5e8f<\/li>\n
                                                  8. \u00a0\u00a0\u00a0\u00a0from\u00a0(<\/li>\n
                                                  9. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0select\u00a0cqk09,cqk05,cqk30,<\/li>\n
                                                  10. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0row_number()\u00a0over(partition\u00a0by\u00a0cqk05\u00a0order\u00a0by\u00a0cqk30\u00a0desc)\u00a0salary_order<\/li>\n
                                                  11. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0from\u00a0cqk_file<\/li>\n
                                                  12. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0where\u00a0cqk03=2012\u00a0and\u00a0cqk031\u00a0=\u00a04\u00a0and\u00a0cqk05\u00a0in(‘2G60′,’2G88’)<\/li>\n
                                                  13. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0)cqk_temp_file<\/li>\n
                                                  14. \u00a0\u00a0\u00a0\u00a0where\u00a0salary_order\u00a0<=\u00a02<\/li>\n<\/ol>\n

                                                    –\u7ed3\u679c\uff1a<\/p>\n\n\n\n\n\n\n\n
                                                    \u59d3\u540d<\/td>\n\u90e8\u9580<\/td>\n\u85aa\u6c34<\/td>\n\u6392\u5e8f<\/td>\n<\/tr>\n
                                                    BX<\/td>\n2G60<\/td>\n77884<\/td>\n1<\/td>\n<\/tr>\n
                                                    AX<\/td>\n2G60<\/td>\n33086<\/td>\n2<\/td>\n<\/tr>\n
                                                    SS<\/td>\n2G88<\/td>\n70994<\/td>\n1<\/td>\n<\/tr>\n
                                                    DX<\/td>\n2G88<\/td>\n56273<\/td>\n2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                                                     <\/p>\n

                                                    row_number() \u3001rownum\u3001rank()\u3001dense_rank()\u5340\u5225\u8aaa\u660e<\/strong>
                                                    \nrow_number() over(partition\u00a0by col1 order by col2)\uff1a\u6b64\u51fd\u6570\u8ba1\u7b97\u7684\u503c\u5c31\u8868\u793a\u6bcf\u7ec4\u5185\u90e8\u6392\u5e8f\u540e\u7684\u987a\u5e8f\u7f16\u53f7(\u7ec4\u5185\u8fde\u7eed\u7684\u552f\u4e00\u7684)<\/p>\n

                                                    row_number()\u548crownum\u5dee\u4e0d\u591a\uff0c\u529f\u80fd\u66f4\u5f3a\u4e00\u70b9(\u53ef\u4ee5\u5728\u5404\u4e2a\u5206\u7ec4\u5185\u4ece1\u5f00\u65f6\u6392\u5e8f)<\/p>\n

                                                    rank()\uff1a\u662f\u8df3\u8dc3\u6392\u5e8f,\u6709\u4e24\u4e2a\u7b2c\u4e8c\u540d\u65f6\u63a5\u4e0b\u6765\u5c31\u662f\u7b2c\u56db\u540d(\u540c\u6837\u662f\u5728\u5404\u4e2a\u5206\u7ec4\u5185)<\/p>\n

                                                    dense_rank()\uff1a\u662f\u8fde\u7eed\u6392\u5e8f,\u6709\u4e24\u4e2a\u7b2c\u4e8c\u540d\u65f6\u4ecd\u7136\u8ddf\u7740\u7b2c\u4e09\u540d.\u76f8\u6bd4\u4e4b\u4e0brow_number\u662f\u6ca1\u6709\u91cd\u590d\u503c\u7684.<\/p>\n

                                                    rank()\u8207dense_rank()\u53carow_number()\u4e0d\u540c\u9ede\u8aaa\u660e<\/strong><\/p>\n

                                                    \u00a0\u00a0rank()\u4f9d\u85aa\u6c34\u6392\u5e8f\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0dense_rank()\u4f9d\u85aa\u6c34\u6392\u5e8f\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 row_number()\u4f9d\u85aa\u6c34\u6392\u5e8f<\/strong><\/p>\n\n\n\n\n\n\n\n
                                                    \u59d3\u540d<\/td>\n\u90e8\u9580<\/td>\n\u85aa\u6c34<\/td>\n\u6392\u5e8f<\/td>\n <\/td>\n\u59d3\u540d<\/td>\n\u90e8\u9580<\/td>\n\u85aa\u6c34<\/td>\n\u6392\u5e8f<\/td>\n <\/td>\n\u59d3\u540d<\/td>\n\u90e8\u9580<\/td>\n\u85aa\u6c34<\/td>\n\u6392\u5e8f<\/td>\n<\/tr>\n
                                                    SI<\/td>\n2BSB<\/td>\n8888<\/td>\n1<\/strong><\/td>\n <\/td>\nSI<\/td>\n2BSB<\/td>\n8888<\/td>\n1<\/strong><\/td>\n <\/td>\nSI<\/td>\n2BSB<\/td>\n8888<\/td>\n1<\/strong><\/td>\n<\/tr>\n
                                                    DI<\/td>\n2BSB<\/td>\n6666<\/td>\n2<\/strong><\/td>\n <\/td>\nDI<\/td>\n2BSB<\/td>\n6666<\/td>\n2<\/strong><\/td>\n <\/td>\nDI<\/td>\n2BSB<\/td>\n6666<\/td>\n2<\/strong><\/td>\n<\/tr>\n
                                                    BP<\/td>\n2BSB<\/td>\n6666<\/td>\n2<\/strong><\/td>\n <\/td>\nBP<\/td>\n2BSB<\/td>\n6666<\/td>\n2<\/strong><\/td>\n <\/td>\nBP<\/td>\n2BSB<\/td>\n6666<\/td>\n3<\/strong><\/td>\n<\/tr>\n
                                                    SP<\/td>\n2BSB<\/td>\n3232<\/td>\n4<\/strong><\/td>\n <\/td>\nSP<\/td>\n2BSB<\/td>\n3232<\/td>\n3<\/strong><\/td>\n <\/td>\nSP<\/td>\n2BSB<\/td>\n3232<\/td>\n4<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                                                     <\/p>\n

                                                    group_id()\uff1a<\/strong>\u5340\u5206\u5206\u7d44\u7d50\u679c\u4e2d\u7684\u91cd\u8907\u884c
                                                    \ngrouping(expr)\uff1a<\/strong>\u7528\u65bc\u78ba\u5b9a\u5206\u7d44\u7d50\u679c\u662f\u5426\u7528\u5230\u4e86\u7279\u5b9a\u7684\u904b\u7b97\u5f0f
                                                    \n\u8fd4\u56de\u503c0\u8868\u793a\u7528\u5230\u4e86\u8a72\u904b\u7b97\u5f0f\uff0c\u8fd4\u56de\u503c1\u8868\u6b7b\u672a\u7528\u5230\u8a72\u904b\u7b97\u5f0f
                                                    \ngrouping_id(expr1[,expr2],,,)\uff1a<\/strong>\u7528\u65bc\u8fd4\u56de\u5c0d\u61c9\u4e8e\u7279\u5b9a\u884c\u7684grouping\u4f4d\u5411\u91cf\u7684\u503c<\/p>\n

                                                    view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                                      \n
                                                    1. select\u00a0apa00,apa13,sum(apa31f),grouping(apa13)<\/li>\n
                                                    2. \u00a0\u00a0from\u00a0apa_file<\/li>\n
                                                    3. \u00a0\u00a0group\u00a0by\u00a0rollup(apa00,apa13)<\/li>\n
                                                    4. \u00a0\u00a0order\u00a0by\u00a0apa00,apa13<\/li>\n<\/ol>\n

                                                      –\u7ed3\u679c\uff1a<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
                                                      APA00<\/td>\nAPA13<\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SUM(APA31F)<\/td>\n\u00a0\u00a0\u00a0\u00a0 GROUPING(APA13)<\/td>\n<\/tr>\n
                                                      11<\/td>\nHKD<\/td>\n23731714.84<\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0 0<\/td>\n<\/tr>\n
                                                      11<\/td>\nNTD<\/td>\n942131<\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a00<\/td>\n<\/tr>\n
                                                      11<\/td>\nRMB<\/td>\n22999119.68<\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/td>\n<\/tr>\n
                                                      11<\/td>\nUSD<\/td>\n2180<\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/td>\n<\/tr>\n
                                                      11<\/td>\n <\/td>\n47675145.52<\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<\/td>\n<\/tr>\n
                                                      12<\/td>\nHKD<\/td>\n107141459.6<\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/td>\n<\/tr>\n
                                                      12<\/td>\nNTD<\/td>\n119680<\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/td>\n<\/tr>\n
                                                      12<\/td>\nRMB<\/td>\n69738785.2<\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/td>\n<\/tr>\n
                                                      12<\/td>\nUSD<\/td>\n92773.7<\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/td>\n<\/tr>\n
                                                      12<\/td>\n <\/td>\n177092698.5<\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<\/td>\n<\/tr>\n
                                                      \u2026<\/strong><\/td>\n\u2026<\/strong><\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2026<\/strong><\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2026<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                                                       <\/p>\n

                                                       <\/p>\n

                                                      view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                                        \n
                                                      1. –\u4e00\u689dSQL\u67e5\u8a62\u51fa\u6240\u6709\u7a0b\u5f0faction\u4e2d\u82f1\u6587\u8aaa\u660e\uff1a<\/li>\n
                                                      2. select\u00a0program\u00a0as\u00a0“\u7a0b\u5f0f\u4ee3\u78bc”,\u00a0gaz03\u00a0as\u00a0“\u7a0b\u5f0f\u540d\u7a31”\u00a0,actionResultList\u00a0as\u00a0“\u7a0b\u5f0f\u529f\u80fd\u6e05\u55ae”<\/li>\n
                                                      3. \u00a0from\u00a0(select\u00a0program,substr(max(sys_connect_by_path(action,’;’)),2)\u00a0as\u00a0actionResultList<\/li>\n
                                                      4. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0from\u00a0(select\u00a0program,action,rank()\u00a0over\u00a0(partition\u00a0by\u00a0actionList.program\u00a0order\u00a0by\u00a0actionList.action\u00a0desc)actionOrder<\/li>\n
                                                      5. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0from\u00a0(select\u00a0gap01\u00a0as\u00a0program,gap02||’:’||gbd04\u00a0as\u00a0action\u00a0from\u00a0gap_file<\/li>\n
                                                      6. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0left\u00a0join\u00a0gbd_file\u00a0on\u00a0gap02\u00a0=\u00a0gbd01<\/li>\n
                                                      7. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0where\u00a0gbd03\u00a0=\u00a0‘0’<\/li>\n
                                                      8. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0)actionList<\/li>\n
                                                      9. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0)actionOrderList<\/li>\n
                                                      10. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0connect\u00a0by\u00a0actionOrder-1\u00a0=\u00a0prior\u00a0actionOrder\u00a0and\u00a0program\u00a0=\u00a0prior\u00a0program<\/li>\n
                                                      11. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0start\u00a0with\u00a0actionOrder\u00a0=\u00a01<\/li>\n
                                                      12. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0group\u00a0by\u00a0program<\/li>\n
                                                      13. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0order\u00a0by\u00a0program<\/li>\n
                                                      14. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0)actionReusltTable<\/li>\n
                                                      15. \u00a0\u00a0\u00a0left\u00a0join\u00a0gaz_file\u00a0on\u00a0program\u00a0=\u00a0gaz01<\/li>\n
                                                      16. \u00a0\u00a0\u00a0where\u00a0gaz02\u00a0=\u00a0‘0’<\/li>\n
                                                      17. \u00a0\u00a0\u00a0order\u00a0by\u00a0program<\/li>\n<\/ol>\n

                                                        –\u7ed3\u679c\uff1a<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
                                                        \u00a0\u00a0\u00a0<\/strong><\/td>\n\u7a0b\u5f0f\u4ee3\u78bc<\/strong><\/td>\n\u7a0b\u5f0f\u540d\u7a31<\/strong><\/td>\n\u7a0b\u5f0f\u529f\u80fd\u6e05\u55ae<\/strong><\/td>\n<\/tr>\n
                                                        1<\/td>\naapi001<\/td>\n\u96c6\u5718\u4ee3\u6536\u4ed8\u57fa\u672c\u8cc7\u6599\u7dad\u8b77\u4f5c\u696d<\/td>\nquery:\u67e5\u8a62;output:\u5217\u5370;locale:\u8a9e\u8a00;help:\u5e6b\u52a9\u2026.<\/td>\n<\/tr>\n
                                                        2<\/td>\naapi010<\/td>\n\u96f6\u7528\u91d1\u61c9\u4ed8\u5e33\u6b3e\u7cfb\u7d71\u55ae\u64da\u6027\u8cea\u7dad\u8b77\u4f5c\u696d<\/td>\ninvalid:\u7121\u6548;insert:\u65b0\u589e;authorization:\u4f7f\u7528\u8005\u8a2d\u9650\u2026<\/td>\n<\/tr>\n
                                                        3<\/td>\naapi101<\/td>\n\u61c9\u4ed8\u5e33\u6b3e\u5404\u671f\u7d71\u8a08\u958b\u5e33\u4f5c\u696d<\/td>\nprevious:\u4e0a\u7b46;next:\u4e0b\u7b46;modify:\u66f4\u6539…<\/td>\n<\/tr>\n
                                                        4<\/td>\naapi102<\/td>\n\u61c9\u4ed8\u5e33\u6b3e(\u4f9d\u55ae\u865f)\u5404\u671f\u7d71\u8a08\u958b\u5e33\u4f5c\u696d<\/td>\nrelated_document:\u76f8\u95dc\u6587\u4ef6;query:\u67e5\u8a62\u2026<\/td>\n<\/tr>\n
                                                        5<\/td>\naapi103<\/td>\n\u61c9\u4ed8\u5e33\u6b3e\u7cfb\u7d71\u55ae\u64da\u6027\u8cea\u7dad\u8b77\u4f5c\u696d<\/td>\ndept_authorization:\u90e8\u9580\u8a2d\u9650;delete:\u522a\u9664\u2026<\/td>\n<\/tr>\n
                                                        6<\/td>\naapi104<\/td>\n\u5e33\u6b3e\u985e\u5225\u7dad\u8b77\u4f5c\u696d<\/td>\nquery:\u67e5\u8a62;qbe_select:\u689d\u4ef6\u67e5\u8a62;qbe_save:\u689d\u4ef6\u5132\u5b58\u2026<\/td>\n<\/tr>\n
                                                        7<\/td>\naapi105<\/td>\n\u7559\u7f6e\u539f\u56e0\u7dad\u8b77\u4f5c\u696d<\/td>\nquery:\u67e5\u8a62\u2026<\/td>\n<\/tr>\n
                                                        8<\/td>\naapi108<\/td>\n\u7d71\u4e00\u7de8\u865f\u8cc7\u6599\u7dad\u8b77\u4f5c\u696d<\/td>\nexit:\u7d50\u675f;delete:\u522a\u9664;controlz:\u5fc5\u8981\u6b04\u4f4d;controlg:\u958b\u7a97\u67e5\u8a62\u2026<\/td>\n<\/tr>\n
                                                        9<\/td>\naapi111<\/td>\n\u96f6\u7528\u91d1\u61c9\u4ed8\u5e33\u6b3e\u5404\u671f\u7d71\u8a08\u958b\u5e33\u4f5c\u696d<\/td>\nprevious:\u4e0a\u7b46;next:\u4e0b\u7b46;modify:\u66f4\u6539insert:\u65b0\u589e;delete:\u522a\u9664\u2026<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                                                         <\/p>\n

                                                         <\/p>\n

                                                        \u7d71\u8a08’Tri-Net’,’AMBER -W’,’Belkin-C’,’GTC’,’SAN SHIN’\u5ba2\u6236\u5404\u6708\u4efd\u63a5\u55ae\u91d1\u984d<\/strong><\/p>\n

                                                        \u8981\u6c42\u8f38\u51fa\u683c\u5f0f\u70ba<\/strong><\/p>\n\n\n\n\n\n
                                                        \u63a5\u55ae\u6708\u4efd<\/td>\nTri-Net<\/td>\nAMBER -W<\/td>\nBelkin-C<\/td>\nGTC<\/td>\nSAN SHIN<\/td>\n<\/tr>\n
                                                        2011\/08<\/td>\n\u63a5\u55ae\u91d1\u984d<\/td>\n\u63a5\u55ae\u91d1\u984d<\/td>\n\u63a5\u55ae\u91d1\u984d<\/td>\n\u63a5\u55ae\u91d1\u984d<\/td>\n\u63a5\u55ae\u91d1\u984d<\/td>\n<\/tr>\n
                                                        \u2026.<\/td>\n\u2026.<\/td>\n\u2026.<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                                                        view plain<\/a>copy to clipboard<\/a>print<\/a>?<\/a><\/p>\n

                                                          \n
                                                        1. with\u00a0cte_oea_file\u00a0as<\/li>\n
                                                        2. (select\u00a0substr(to_char(oea02,’YYYY\/MM\/DD’),1,7)\u00a0po_date,oea032\u00a0po_custom,sum(oeb14)\u00a0po_sales<\/li>\n
                                                        3. \u00a0\u00a0\u00a0from\u00a0oea_file\u00a0join\u00a0oeb_file\u00a0on\u00a0oea01\u00a0=\u00a0oeb01<\/li>\n
                                                        4. \u00a0\u00a0\u00a0where\u00a0oea032\u00a0in\u00a0(‘Tri-Net’,’AMBER\u00a0-W’,’Belkin-C’,’GTC’,’SAN\u00a0SHIN’)<\/li>\n
                                                        5. \u00a0\u00a0\u00a0group\u00a0by\u00a0substr(to_char(oea02,’YYYY\/MM\/DD’),1,7),oea032<\/li>\n
                                                        6. \u00a0\u00a0order\u00a0by\u00a01,2<\/li>\n
                                                        7. )<\/li>\n
                                                        8. select\u00a0po_date\u00a0“\u63a5\u55ae\u6708\u4efd”,<\/li>\n
                                                        9. \u00a0\u00a0\u00a0sum(decode(po_custom,’Tri-Net’,po_sales,0))\u00a0\u00a0“Tri-Net”,<\/li>\n
                                                        10. \u00a0\u00a0\u00a0sum(decode(po_custom,’AMBER\u00a0-W’,po_sales,0))\u00a0“AMBER\u00a0-W”,<\/li>\n
                                                        11. \u00a0\u00a0\u00a0sum(decode(po_custom,’Belkin-C’,po_sales,0))\u00a0“Belkin-C”,<\/li>\n
                                                        12. \u00a0\u00a0\u00a0sum(decode(po_custom,’GTC’,po_sales,0))\u00a0“GTC”,<\/li>\n
                                                        13. \u00a0\u00a0\u00a0sum(decode(po_custom,’SAN\u00a0SHIN’,po_sales,0))\u00a0“SAN\u00a0SHIN”<\/li>\n
                                                        14. \u00a0from\u00a0cte_oea_file<\/li>\n
                                                        15. \u00a0group\u00a0by\u00a0po_date<\/li>\n
                                                        16. \u00a0order\u00a0by\u00a0po_date<\/li>\n<\/ol>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
                                                          \u63a5\u55ae\u6708\u4efd<\/strong><\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Tri-Net<\/strong><\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0AMBER -W<\/strong><\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Belkin-C<\/strong><\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 GTC<\/strong><\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SAN SHIN<\/strong><\/td>\n<\/tr>\n
                                                          2011\/08<\/td>\n768796.48<\/td>\n161573.68<\/td>\n14162.5<\/td>\n319450<\/td>\n10250.96<\/td>\n<\/tr>\n
                                                          2011\/09<\/td>\n566008.26<\/td>\n221550.9<\/td>\n258366.5<\/td>\n268070<\/td>\n8920<\/td>\n<\/tr>\n
                                                          2011\/10<\/td>\n270341.68<\/td>\n76241.95<\/td>\n147402<\/td>\n85850<\/td>\n9020<\/td>\n<\/tr>\n
                                                          2011\/11<\/td>\n464575.39<\/td>\n0<\/td>\n284704<\/td>\n469675<\/td>\n15040<\/td>\n<\/tr>\n
                                                          2011\/12<\/td>\n295007.55<\/td>\n0<\/td>\n140446.2<\/td>\n918000<\/td>\n21250<\/td>\n<\/tr>\n
                                                          2012\/01<\/td>\n70835.5<\/td>\n0<\/td>\n0<\/td>\n274850<\/td>\n5100<\/td>\n<\/tr>\n
                                                          2012\/02<\/td>\n148424.53<\/td>\n0<\/td>\n1425<\/td>\n235255<\/td>\n40690<\/td>\n<\/tr>\n
                                                          2012\/03<\/td>\n179333.31<\/td>\n0<\/td>\n0<\/td>\n638550<\/td>\n55596.4<\/td>\n<\/tr>\n
                                                          2012\/04<\/td>\n158162.51<\/td>\n0<\/td>\n0<\/td>\n212000<\/td>\n10110<\/td>\n<\/tr>\n
                                                          2012\/05<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n220600<\/td>\n30160<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                                                          \u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u8d6b\u975e\u57df<\/a> » Oracle SQL\u5185\u7f6e\u51fd\u6570\u6d4b\u8bd5<\/a><\/p>","protected":false},"excerpt":{"rendered":"

                                                          Oracle SQL\u5185\u7f6e\u51fd\u6570 Oracle\u5185\u7f6eSQL\u51fd\u6570\u4e3b\u8981\u5206\u4e3a\u4e00\u4e0b\u7c7b\u522b\uff1a\u6570\u5b57\u51fd\u6570\u3001\u5b57\u7b26\u51fd\u6570\u3001\u65e5\u671f\u51fd\u6570\u3001\u8f6c\u6362\u51fd\u6570\u3001\u96c6\u5408\u51fd\u6570\u3001\u5206\u6790\/\u805a\u5408\u51fd\u6570 \u672c\u624b\u518c\u6240\u6709\u793a\u4f8b\u5747\u4ee5TIPTOP GP 5.10 ERP\u6570\u636e\u5e93\u8868\u4e3a\u57fa\u7840\u6f14\u793a   1\u3001\u6570\u5b57\u51fd\u6570 abs( […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[305,306,307],"class_list":["post-1028","post","type-post","status-publish","format-standard","hentry","category-unix","tag-305","tag-306","tag-307"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/1028","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1028"}],"version-history":[{"count":1,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/1028\/revisions"}],"predecessor-version":[{"id":1029,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/1028\/revisions\/1029"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}