Connected to
Connected as WCDMA
SQL>
SQL> SELECT SUNDAY.THE_WEEK,
2 DECODE(SIGN(SUNDAY.THE_DAY - SATURDAY.THE_DAY),
3 -1,
4 SUNDAY.THE_DAY,
5 SUNDAY.THE_DAY - 7) SUNDAY,
6 SATURDAY.THE_DAY SATURDAY
7 FROM (SELECT TO_CHAR(WWM, 'WW') THE_WEEK,
8 TO_CHAR(WWM, 'D') THE_DAYNUM,
9 WWM THE_DAY
10 FROM (SELECT TRUNC( To_Date('2012-01-01','YYYY-MM-DD'), 'MM') + ROWNUM - 1 AS WWM
11 FROM USER_OBJECTS
12 WHERE ROWNUM < 366)
13 WHERE TO_CHAR(WWM, 'D') = 1) SUNDAY,
14 (SELECT TO_CHAR(WWM, 'WW') THE_WEEK,
15 TO_CHAR(WWM, 'D') THE_DAYNUM,
16 WWM THE_DAY
17 FROM (SELECT TRUNC(To_Date('2012-01-01','YYYY-MM-DD'), 'MM') + ROWNUM - 1 AS WWM
18 FROM USER_OBJECTS
19 WHERE ROWNUM < 366)
20 WHERE TO_CHAR(WWM, 'D') = 7) SATURDAY
21 WHERE SUNDAY.THE_WEEK = SATURDAY.THE_WEEK
22 ;
THE_WEEK SUNDAY SATURDAY
-------- ----------- -----------
01 2012-1-1 2012-1-7
02 2012-1-8 2012-1-14
03 2012-1-15 2012-1-21
04 2012-1-22 2012-1-28
05 2012-1-29 2012-2-4
06 2012-2-5 2012-2-11
07 2012-2-12 2012-2-18
08 2012-2-19 2012-2-25
09 2012-2-26 2012-3-3
10 2012-3-4 2012-3-10
11 2012-3-11 2012-3-17
12 2012-3-18 2012-3-24
13 2012-3-25 2012-3-31
14 2012-4-1 2012-4-7
15 2012-4-8 2012-4-14
16 2012-4-15 2012-4-21
17 2012-4-22 2012-4-28
18 2012-4-29 2012-5-5
19 2012-5-6 2012-5-12
20 2012-5-13 2012-5-19
21 2012-5-20 2012-5-26
22 2012-5-27 2012-6-2
23 2012-6-3 2012-6-9
24 2012-6-10 2012-6-16
25 2012-6-17 2012-6-23
26 2012-6-24 2012-6-30
27 2012-7-1 2012-7-7
28 2012-7-8 2012-7-14
29 2012-7-15 2012-7-21
30 2012-7-22 2012-7-28
31 2012-7-29 2012-8-4
32 2012-8-5 2012-8-11
33 2012-8-12 2012-8-18
34 2012-8-19 2012-8-25
35 2012-8-26 2012-9-1
36 2012-9-2 2012-9-8
37 2012-9-9 2012-9-15
38 2012-9-16 2012-9-22
39 2012-9-23 2012-9-29
40 2012-9-30 2012-10-6
41 2012-10-7 2012-10-13
42 2012-10-14 2012-10-20
43 2012-10-21 2012-10-27
44 2012-10-28 2012-11-3
45 2012-11-4 2012-11-10
46 2012-11-11 2012-11-17
47 2012-11-18 2012-11-24
48 2012-11-25 2012-12-1
49 2012-12-2 2012-12-8
50 2012-12-9 2012-12-15
51 2012-12-16 2012-12-22
52 2012-12-23 2012-12-29
52 rows selected
SQL>