I have to give some statistic what departments and what time logged in at the
database.
I use for that pivot query.
SQL> select dept,
2 max(decode(substr(timeused,1,2),'08',cnt,null)) 08-09,
3 max(decode(substr(timeused,1,2),'09',cnt,null)) 09-10,
4 max(decode(substr(timeused,1,2),'10',cnt,null)) 10-11,
5 max(decode(substr(timeused,1,2),'11',cnt,null)) 11-12,
6 max(decode(substr(timeused,1,2),'12',cnt,null)) 12-13,
8 max(decode(substr(timeused,1,2),'13',cnt,null)) 13-14,
9 max(decode(substr(timeused,1,2),'14',cnt,null)) 14-15,
10 max(decode(substr(timeused,1,2),'15',cnt,null)) 15-16,
11 max(decode(substr(timeused,1,2),'16',cnt,null)) 16-17,
12 max(decode(substr(timeused,1,2),'17',cnt,null)) 17-18,
13 max(decode(substr(timeused,1,2),'18',cnt,null)) 18-19,
14 max(decode(substr(timeused,1,2),'19',cnt,null)) 19-20
15 from (select dept,
16 decode (substr(timeused,1,2),'08','08-09','09','09-10','10','10-
11','11',
17 '11-12','12','12-13','01','13-14','02','14-15','03','15-
16','04','16-17',
18 '05','17-18','06','18-19','07','19-20'),count(*) cnt
19 from visits,users
20 where to_date(dateused,'DD-MON-RR') ='15-AUG-02'
21 and visits.id=users.id
22 group by dept,
23 decode (substr(timeused,1,2),'08','08-09','09','09-10','10','10-
11','11','11-12','12','12-13','01','13-14','02','14-15','03','15-
16','16','04','16-17','05','17-18','06','18-19','07','19-20'))
25 group by dept;
And I have ERROR at line 2:
ORA-00923: FROM keyword not found where expected
Please help. Thanks in advanced.
|
] 
Blog
Search
Help
Members
Register
Login
Home
