Toad World® Forums

How to update column (ISO_WEEK) in TOAD Oracle?


#1

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)