SET ISO_WEEK = ISO_YEAR || ‘WK53’
WHERE
ISO_WEEK = 52 AND
MONTH_OF_CALENDER_YEAR = 12 AND
DAY_OF_CALENDER_MONTH <= 31 AND
COUNT(ISO_WEEK_IN_YEAR) > 7
Hi
I have this set of data below in our oracle table:
CALENDAR_DATE ISO_WEEK
20/12/2009 2009W52
21/12/2009 2009W52
22/12/2009 2009W52
23/12/2009 2009W52
24/12/2009 2009W52
25/12/2009 2009W52
26/12/2009 2009W52
27/12/2009 2009W52
28/12/2009 2009W52
29/12/2009 2009W52
30/12/2009 2009W52
31/12/2009 2009W52
And I want to update to this one below:
CALENDAR_DATE ISO_WEEK
20/12/2009 2009W52
21/12/2009 2009W52
22/12/2009 2009W52
23/12/2009 2009W52
24/12/2009 2009W52
25/12/2009 2009W52
26/12/2009 2009W52
27/12/2009 2009W53
28/12/2009 2009W53
29/12/2009 2009W53
30/12/2009 2009W53
31/12/2009 2009W53
Here is my script I used but currently it didn’t work.
UPDATE (select COUNT(ISO_WEEK_IN_YEAR) from AW_WAREHOUSE_TIME_DIM2)
Can anyone help me on this one?
Your response is highly appreciate
yearend.zip (21.3 KB)