31
select student,trunc(hour,'mm') as period,sum(attempts) as attemptsfrom library_website_users a join library_website_stats b using (student_id)where trunc(hour,'yyyy') = trunc(to_date(:year_selected,'yyyy'),'yyyy')group by student,trunc(hour,'mm')order by trunc(hour,'mm'),student
When I run the above the coding on SQL Developer it gave me a error:
SQL Error: Missing IN or OUT parameter at index:: 1
Can anyone help me on this problem? Thanks.
Which place should I put this statment at e.g put it under functions ,types,trigger etc etc.
