{"id":320,"date":"2013-01-12T16:58:54","date_gmt":"2013-01-12T08:58:54","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=320"},"modified":"2013-01-12T18:06:32","modified_gmt":"2013-01-12T10:06:32","slug":"scripts%ef%bc%9a%e6%9f%a5%e7%9c%8b%e6%95%b0%e6%8d%ae%e5%ba%93%e6%97%a5%e5%bf%97%e5%88%87%e6%8d%a2%e9%a2%91%e7%8e%87","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=320","title":{"rendered":"scripts:\u67e5\u770b\u6570\u636e\u5e93\u65e5\u5fd7\u5207\u6362\u9891\u7387"},"content":{"rendered":"

\u67e5\u770b\u6570\u636e\u5e93\u65e5\u5fd7\u5207\u6362\u9891\u7387
\n
\nSET LINESIZE 145
\nSET PAGESIZE 9999
\nSET VERIFY off
\nCOLUMN H00 FORMAT 999 HEADING '00'
\nCOLUMN H01 FORMAT 999 HEADING '01'
\nCOLUMN H02 FORMAT 999 HEADING '02'
\nCOLUMN H03 FORMAT 999 HEADING '03'
\nCOLUMN H04 FORMAT 999 HEADING '04'
\nCOLUMN H05 FORMAT 999 HEADING '05'
\nCOLUMN H06 FORMAT 999 HEADING '06'
\nCOLUMN H07 FORMAT 999 HEADING '07'
\nCOLUMN H08 FORMAT 999 HEADING '08'
\nCOLUMN H09 FORMAT 999 HEADING '09'
\nCOLUMN H10 FORMAT 999 HEADING '10'
\nCOLUMN H11 FORMAT 999 HEADING '11'
\nCOLUMN H12 FORMAT 999 HEADING '12'
\nCOLUMN H13 FORMAT 999 HEADING '13'
\nCOLUMN H14 FORMAT 999 HEADING '14'
\nCOLUMN H15 FORMAT 999 HEADING '15'
\nCOLUMN H16 FORMAT 999 HEADING '16'
\nCOLUMN H17 FORMAT 999 HEADING '17'
\nCOLUMN H18 FORMAT 999 HEADING '18'
\nCOLUMN H19 FORMAT 999 HEADING '19'
\nCOLUMN H20 FORMAT 999 HEADING '20'
\nCOLUMN H21 FORMAT 999 HEADING '21'
\nCOLUMN H22 FORMAT 999 HEADING '22'
\nCOLUMN H23 FORMAT 999 HEADING '23'
\nCOLUMN TOTAL FORMAT 999,999 HEADING 'Total'
\nSELECT
\n SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH:MI:SS'),1,5) DAY
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'00',1,0)) H00
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'01',1,0)) H01
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'02',1,0)) H02
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'03',1,0)) H03
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'04',1,0)) H04
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'05',1,0)) H05
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'06',1,0)) H06
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'07',1,0)) H07
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'08',1,0)) H08
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'09',1,0)) H09
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'10',1,0)) H10
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'11',1,0)) H11
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'12',1,0)) H12
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'13',1,0)) H13
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'14',1,0)) H14
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'15',1,0)) H15
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'16',1,0)) H16
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'17',1,0)) H17
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'18',1,0)) H18
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'19',1,0)) H19
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'20',1,0)) H20
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'21',1,0)) H21
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'22',1,0)) H22
\n , SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH24:MI:SS'),10,2),'23',1,0)) H23
\n , COUNT(*) TOTAL
\nFROM v$log_history a
\nGROUP BY SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH:MI:SS'),1,5)
\nORDER BY SUBSTR(TO_CHAR(first_time, 'MM\/DD\/RR HH:MI:SS'),1,5);
\n\/
\n<\/coolcode><\/p>\n","protected":false},"excerpt":{"rendered":"

\u67e5\u770b\u6570\u636e\u5e93\u65e5\u5fd7\u5207\u6362\u9891\u7387 SET LINESIZE 145 SET PAGESIZE 9999 SET VERI […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/320"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=320"}],"version-history":[{"count":3,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/320\/revisions"}],"predecessor-version":[{"id":372,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/320\/revisions\/372"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=320"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}