Useful way to group data by week to avoid the quandary of weeks overlapping months and years.CREATE OR REPLACE PROCEDURE weekly_proc IS CURSOR x_cur IS SELECT DISTINCT SUBSTR(TO_CHAR(date1),4,3) m, SUBSTR(TO_CHAR(date1),1,2) w, COUNT (*) cntFROM cpad_errorsGROUP BY SUBSTR(TO_CHAR(date1),4,3), SUBSTR(TO_CHAR(date1),1,2); x_rec x_cur%ROWTYPE; week_var NUMBER; BEGIN EXECUTE IMMEDIATE 'truncate table week_test'; OPEN x_cur;...
Read more »