Hi
Here is the draft of script you needed:
DECLARE
tuesday_no NUMBER (1);
is_tuesday_now NUMBER (1);
BEGIN
SELECT CASE
WHEN TO_NUMBER (TO_CHAR (SYSDATE, 'D')) = 5
THEN 1
ELSE 0
END CASE,
TRUNC (TO_NUMBER (TO_CHAR (SYSDATE, 'DD')) / 7) + 1
INTO is_tuesday_now,
tuesday_no
FROM DUAL;
UPDATE your_table
SET your_field =
DECODE (tuesday_no,
1, 'a',
2, 'b',
3, 'c',
4, 'd',
'?'
);
END;
I can make it in one query if needed. But I would like to get more details.
Looking forward to continue.
Constantine