Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- to_char(first_time,'DD.MM.YYYY') DAY,
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'00',1,0)),'999') "00",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'01',1,0)),'999') "01",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'02',1,0)),'999') "02",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'03',1,0)),'999') "03",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'04',1,0)),'999') "04",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'05',1,0)),'999') "05",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'06',1,0)),'999') "06",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'07',1,0)),'999') "07",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'08',1,0)),'999') "08",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'09',1,0)),'999') "09",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'10',1,0)),'999') "10",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'11',1,0)),'999') "11",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'12',1,0)),'999') "12",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'13',1,0)),'999') "13",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'14',1,0)),'999') "14",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'15',1,0)),'999') "15",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'16',1,0)),'999') "16",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'17',1,0)),'999') "17",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'18',1,0)),'999') "18",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'19',1,0)),'999') "19",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'20',1,0)),'999') "20",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'21',1,0)),'999') "21",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'22',1,0)),'999') "22",
- to_char(SUM(decode(substr(to_char(first_time,'HH24'),1,2),'23',1,0)),'999') "23",
- COUNT(*) TOT
- FROM
- v$log_history
- WHERE first_time > SYSDATE-14
- GROUP BY
- to_char(first_time,'DD.MM.YYYY')
- ORDER BY
- to_date(DAY, 'DD.MM.YYYY');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement