Oracle does not accept column labels in the GROUP BY section - get_logs_usercourse() and get_logs_userday() were computing the day/hours column and using it in the GROUP BY.
Credit for the fix goes to Dennis Rochford <Dennis.Rochford@usq.edu.au>.
Oracle does not accept column labels in the GROUP BY section - get_logs_usercourse() and get_logs_userday() were computing the day/hours column and using it in the GROUP BY.
Credit for the fix goes to Dennis Rochford <Dennis.Rochford@usq.edu.au>.