Oracle Live SQL - Script: Select_analytics

Statement 1

create table values as 
(code varchar2(10), 
date_value date, 
value number)

ORA-00903: invalid table name

More Details: https://docs.oracle.com/error-help/db/ora-00903

Statement 2

create table test_values as 
(code varchar2(10), 
date_value date, 
value number)

ORA-00928: missing SELECT keyword

More Details: https://docs.oracle.com/error-help/db/ora-00928

Statement 3

create table test_values as 
(code varchar2(10), 
date_value date, 
value number)

ORA-00928: missing SELECT keyword

More Details: https://docs.oracle.com/error-help/db/ora-00928

Statement 4

create table test_values as 
(code varchar2(10), 
date_value date, 
test_value number)

ORA-00928: missing SELECT keyword

More Details: https://docs.oracle.com/error-help/db/ora-00928

Statement 5

create table test_values ( 
    code varchar2(10) not null, 
    date_value date not null, 
    test_value number 
)

Table created.

Statement 6

create table test_calendar ( 
    cal_date date not null constraint test_calendar_pk primary key 
)

Table created.

Statement 7

DECLARE 
  w_dat date; 
BEGIN 
  w_dat:=to_date('01012015','ddmmyyyy'); 
  loop 
    insert into test_calendar (cal_date) values (trunc(w_dat)); 
    w_dat:=w_dat+1; 
    if w_dat>to_date('31122019','ddmmyyyy') then 
      exit; 
    end if; 
  end loop; 
  commit; 
END;

1 row(s) inserted.

Statement 8

select  
    "CAL_DATE" 
from "TEST_CALENDAR"


CAL_DATE
21-JAN-18
22-JAN-18
23-JAN-18
24-JAN-18
25-JAN-18
26-JAN-18
27-JAN-18
28-JAN-18
29-JAN-18
30-JAN-18
31-JAN-18
01-FEB-18
02-FEB-18
03-FEB-18
04-FEB-18
05-FEB-18
06-FEB-18
07-FEB-18
08-FEB-18
09-FEB-18
10-FEB-18
11-FEB-18
12-FEB-18
13-FEB-18
14-FEB-18
15-FEB-18
16-FEB-18
17-FEB-18
18-FEB-18
19-FEB-18
20-FEB-18
21-FEB-18
22-FEB-18
23-FEB-18
24-FEB-18
25-FEB-18
26-FEB-18
27-FEB-18
28-FEB-18
01-MAR-18
02-MAR-18
03-MAR-18
04-MAR-18
05-MAR-18
06-MAR-18
07-MAR-18
08-MAR-18
09-MAR-18
10-MAR-18
11-MAR-18
12-MAR-18
13-MAR-18
14-MAR-18
15-MAR-18
16-MAR-18
17-MAR-18
18-MAR-18
19-MAR-18
20-MAR-18
21-MAR-18
22-MAR-18
23-MAR-18
24-MAR-18
25-MAR-18
26-MAR-18
27-MAR-18
28-MAR-18
29-MAR-18
30-MAR-18
31-MAR-18
01-APR-18
02-APR-18
03-APR-18
04-APR-18
05-APR-18
06-APR-18
07-APR-18
08-APR-18
09-APR-18
10-APR-18
11-APR-18
12-APR-18
13-APR-18
14-APR-18
15-APR-18
16-APR-18
17-APR-18
18-APR-18
19-APR-18
20-APR-18
21-APR-18
22-APR-18
23-APR-18
24-APR-18
25-APR-18
26-APR-18
27-APR-18
28-APR-18
29-APR-18
30-APR-18
01-MAY-18
02-MAY-18
03-MAY-18
04-MAY-18
05-MAY-18
06-MAY-18
07-MAY-18
08-MAY-18
09-MAY-18
10-MAY-18
11-MAY-18
12-MAY-18
13-MAY-18
14-MAY-18
15-MAY-18
16-MAY-18
17-MAY-18
18-MAY-18
19-MAY-18
20-MAY-18
21-MAY-18
22-MAY-18
23-MAY-18
24-MAY-18
25-MAY-18
26-MAY-18
27-MAY-18
28-MAY-18
29-MAY-18
30-MAY-18
31-MAY-18
01-JUN-18
02-JUN-18
03-JUN-18
04-JUN-18
05-JUN-18
06-JUN-18
07-JUN-18
08-JUN-18
09-JUN-18
10-JUN-18
11-JUN-18
12-JUN-18
13-JUN-18
14-JUN-18
15-JUN-18
16-JUN-18
17-JUN-18
18-JUN-18
19-JUN-18
20-JUN-18
21-JUN-18
22-JUN-18
23-JUN-18
24-JUN-18
25-JUN-18
26-JUN-18
27-JUN-18
28-JUN-18
29-JUN-18
30-JUN-18
01-JUL-18
02-JUL-18
03-JUL-18
04-JUL-18
05-JUL-18
06-JUL-18
07-JUL-18
08-JUL-18
09-JUL-18
10-JUL-18
11-JUL-18
12-JUL-18
13-JUL-18
14-JUL-18
15-JUL-18
16-JUL-18
17-JUL-18
18-JUL-18
19-JUL-18
20-JUL-18
21-JUL-18
22-JUL-18
23-JUL-18
24-JUL-18
25-JUL-18
26-JUL-18
27-JUL-18
28-JUL-18
29-JUL-18
30-JUL-18
31-JUL-18
01-AUG-18
02-AUG-18
03-AUG-18
04-AUG-18
05-AUG-18
06-AUG-18
07-AUG-18
08-AUG-18
09-AUG-18
10-AUG-18
11-AUG-18
12-AUG-18
13-AUG-18
14-AUG-18
15-AUG-18
16-AUG-18
17-AUG-18
18-AUG-18
19-AUG-18
20-AUG-18
21-AUG-18
22-AUG-18
23-AUG-18
24-AUG-18
25-AUG-18
26-AUG-18
27-AUG-18
28-AUG-18
29-AUG-18
30-AUG-18
31-AUG-18
01-SEP-18
02-SEP-18
03-SEP-18
04-SEP-18
05-SEP-18
06-SEP-18
07-SEP-18
08-SEP-18
09-SEP-18
10-SEP-18
11-SEP-18
12-SEP-18
13-SEP-18
14-SEP-18
15-SEP-18
16-SEP-18
17-SEP-18
18-SEP-18
19-SEP-18
20-SEP-18
21-SEP-18
22-SEP-18
23-SEP-18
24-SEP-18
25-SEP-18
26-SEP-18
27-SEP-18
28-SEP-18
29-SEP-18
30-SEP-18
01-OCT-18
02-OCT-18
03-OCT-18
04-OCT-18
05-OCT-18
06-OCT-18
07-OCT-18
08-OCT-18
09-OCT-18
10-OCT-18
11-OCT-18
12-OCT-18
13-OCT-18
14-OCT-18
15-OCT-18
16-OCT-18
17-OCT-18
18-OCT-18
19-OCT-18
20-OCT-18
21-OCT-18
22-OCT-18
23-OCT-18
24-OCT-18
25-OCT-18
26-OCT-18
27-OCT-18
28-OCT-18
29-OCT-18
30-OCT-18
31-OCT-18
01-NOV-18
02-NOV-18
03-NOV-18
04-NOV-18
05-NOV-18
06-NOV-18
07-NOV-18
08-NOV-18
09-NOV-18
10-NOV-18
11-NOV-18
12-NOV-18
13-NOV-18
14-NOV-18
15-NOV-18
16-NOV-18
17-NOV-18
18-NOV-18
19-NOV-18
20-NOV-18
21-NOV-18
22-NOV-18
23-NOV-18
24-NOV-18
25-NOV-18
26-NOV-18
27-NOV-18
28-NOV-18
29-NOV-18
30-NOV-18
01-DEC-18
02-DEC-18
03-DEC-18
04-DEC-18
05-DEC-18
06-DEC-18
07-DEC-18
08-DEC-18
09-DEC-18
10-DEC-18
11-DEC-18
12-DEC-18
13-DEC-18
14-DEC-18
15-DEC-18
16-DEC-18
17-DEC-18
18-DEC-18
19-DEC-18
20-DEC-18
21-DEC-18
22-DEC-18
23-DEC-18
24-DEC-18
25-DEC-18
26-DEC-18
27-DEC-18
28-DEC-18
29-DEC-18
30-DEC-18
31-DEC-18
01-JAN-19
02-JAN-19
03-JAN-19
04-JAN-19
05-JAN-19
06-JAN-19
07-JAN-19
08-JAN-19
09-JAN-19
10-JAN-19
11-JAN-19
12-JAN-19
13-JAN-19
14-JAN-19
15-JAN-19
16-JAN-19
17-JAN-19
18-JAN-19
19-JAN-19
20-JAN-19
21-JAN-19
22-JAN-19
23-JAN-19
24-JAN-19
25-JAN-19
26-JAN-19
27-JAN-19
28-JAN-19
29-JAN-19
30-JAN-19
31-JAN-19
01-FEB-19
02-FEB-19
03-FEB-19
04-FEB-19
05-FEB-19
06-FEB-19
07-FEB-19
08-FEB-19
09-FEB-19
10-FEB-19
11-FEB-19
12-FEB-19
13-FEB-19
14-FEB-19
15-FEB-19
16-FEB-19
17-FEB-19
18-FEB-19
19-FEB-19
20-FEB-19
21-FEB-19
22-FEB-19
23-FEB-19
24-FEB-19
25-FEB-19
26-FEB-19
27-FEB-19
28-FEB-19
01-MAR-19
02-MAR-19
03-MAR-19
04-MAR-19
05-MAR-19
06-MAR-19
07-MAR-19
08-MAR-19
09-MAR-19
10-MAR-19
11-MAR-19
12-MAR-19
13-MAR-19
14-MAR-19
15-MAR-19
16-MAR-19
17-MAR-19
18-MAR-19
19-MAR-19
20-MAR-19
21-MAR-19
22-MAR-19
23-MAR-19
24-MAR-19
25-MAR-19
26-MAR-19
27-MAR-19
28-MAR-19
29-MAR-19
30-MAR-19
31-MAR-19
01-APR-19
02-APR-19
03-APR-19
04-APR-19
05-APR-19
06-APR-19
07-APR-19
08-APR-19
09-APR-19
10-APR-19
11-APR-19
12-APR-19
13-APR-19
14-APR-19
15-APR-19
16-APR-19
17-APR-19
18-APR-19
19-APR-19
20-APR-19
21-APR-19
22-APR-19
23-APR-19
24-APR-19
25-APR-19
26-APR-19
27-APR-19
28-APR-19
29-APR-19
30-APR-19
01-MAY-19
02-MAY-19
03-MAY-19
04-MAY-19
05-MAY-19
06-MAY-19
07-MAY-19
08-MAY-19
09-MAY-19
10-MAY-19
11-MAY-19
12-MAY-19
13-MAY-19
14-MAY-19
15-MAY-19
16-MAY-19
17-MAY-19
18-MAY-19
19-MAY-19
20-MAY-19
21-MAY-19
22-MAY-19
23-MAY-19
24-MAY-19
25-MAY-19
26-MAY-19
27-MAY-19
28-MAY-19
29-MAY-19
30-MAY-19
31-MAY-19
01-JUN-19
02-JUN-19
03-JUN-19
04-JUN-19
05-JUN-19
06-JUN-19
07-JUN-19
08-JUN-19
09-JUN-19
10-JUN-19
11-JUN-19
12-JUN-19
13-JUN-19
14-JUN-19
15-JUN-19
16-JUN-19
17-JUN-19
18-JUN-19
19-JUN-19
20-JUN-19
21-JUN-19
22-JUN-19
23-JUN-19
24-JUN-19
25-JUN-19
26-JUN-19
27-JUN-19
28-JUN-19
29-JUN-19
30-JUN-19
01-JUL-19
02-JUL-19
03-JUL-19
04-JUL-19
05-JUL-19
06-JUL-19
07-JUL-19
08-JUL-19
09-JUL-19
10-JUL-19
11-JUL-19
12-JUL-19
13-JUL-19
14-JUL-19
15-JUL-19
16-JUL-19
17-JUL-19
18-JUL-19
19-JUL-19
20-JUL-19
21-JUL-19
22-JUL-19
23-JUL-19
24-JUL-19
25-JUL-19
26-JUL-19
27-JUL-19
28-JUL-19
29-JUL-19
30-JUL-19
31-JUL-19
01-AUG-19
02-AUG-19
03-AUG-19
04-AUG-19
05-AUG-19
06-AUG-19
07-AUG-19
08-AUG-19
09-AUG-19
10-AUG-19
11-AUG-19
12-AUG-19
13-AUG-19
14-AUG-19
15-AUG-19
16-AUG-19
17-AUG-19
18-AUG-19
19-AUG-19
20-AUG-19
21-AUG-19
22-AUG-19
23-AUG-19
24-AUG-19
25-AUG-19
26-AUG-19
27-AUG-19
28-AUG-19
29-AUG-19
30-AUG-19
31-AUG-19
01-SEP-19
02-SEP-19
03-SEP-19
04-SEP-19
05-SEP-19
06-SEP-19
07-SEP-19
08-SEP-19
09-SEP-19
10-SEP-19
11-SEP-19
12-SEP-19
13-SEP-19
14-SEP-19
15-SEP-19
16-SEP-19
17-SEP-19
18-SEP-19
19-SEP-19
20-SEP-19
21-SEP-19
22-SEP-19
23-SEP-19
24-SEP-19
25-SEP-19
26-SEP-19
27-SEP-19
28-SEP-19
29-SEP-19
30-SEP-19
01-OCT-19
02-OCT-19
03-OCT-19
04-OCT-19
05-OCT-19
06-OCT-19
07-OCT-19
08-OCT-19
09-OCT-19
10-OCT-19
11-OCT-19
12-OCT-19
13-OCT-19
14-OCT-19
15-OCT-19
16-OCT-19
17-OCT-19
18-OCT-19
19-OCT-19
20-OCT-19
21-OCT-19
22-OCT-19
23-OCT-19
24-OCT-19
25-OCT-19
26-OCT-19
27-OCT-19
28-OCT-19
29-OCT-19
30-OCT-19
31-OCT-19
01-NOV-19
02-NOV-19
03-NOV-19
04-NOV-19
05-NOV-19
06-NOV-19
07-NOV-19
08-NOV-19
09-NOV-19
10-NOV-19
11-NOV-19
12-NOV-19
13-NOV-19
14-NOV-19
15-NOV-19
16-NOV-19
17-NOV-19
18-NOV-19
19-NOV-19
20-NOV-19
21-NOV-19
22-NOV-19
23-NOV-19
24-NOV-19
25-NOV-19
26-NOV-19
27-NOV-19
28-NOV-19
29-NOV-19
30-NOV-19
01-DEC-19
02-DEC-19
03-DEC-19
04-DEC-19
05-DEC-19
06-DEC-19
07-DEC-19
08-DEC-19
09-DEC-19
10-DEC-19
11-DEC-19
12-DEC-19
13-DEC-19
14-DEC-19
15-DEC-19
16-DEC-19
17-DEC-19
18-DEC-19
19-DEC-19
20-DEC-19
21-DEC-19
22-DEC-19
23-DEC-19
24-DEC-19
25-DEC-19
26-DEC-19
27-DEC-19
28-DEC-19
29-DEC-19
30-DEC-19
31-DEC-19
01-JAN-15
02-JAN-15
03-JAN-15
04-JAN-15
05-JAN-15
06-JAN-15
07-JAN-15
08-JAN-15
09-JAN-15
10-JAN-15
11-JAN-15
12-JAN-15
13-JAN-15
14-JAN-15
15-JAN-15
16-JAN-15
17-JAN-15
18-JAN-15
19-JAN-15
20-JAN-15
21-JAN-15
22-JAN-15
23-JAN-15
24-JAN-15
25-JAN-15
26-JAN-15
27-JAN-15
28-JAN-15
29-JAN-15
30-JAN-15
31-JAN-15
01-FEB-15
02-FEB-15
03-FEB-15
04-FEB-15
05-FEB-15
06-FEB-15
07-FEB-15
08-FEB-15
09-FEB-15
10-FEB-15
11-FEB-15
12-FEB-15
13-FEB-15
14-FEB-15
15-FEB-15
16-FEB-15
17-FEB-15
18-FEB-15
19-FEB-15
20-FEB-15
21-FEB-15
22-FEB-15
23-FEB-15
24-FEB-15
25-FEB-15
26-FEB-15
27-FEB-15
28-FEB-15
01-MAR-15
02-MAR-15
03-MAR-15
04-MAR-15
05-MAR-15
06-MAR-15
07-MAR-15
08-MAR-15
09-MAR-15
10-MAR-15
11-MAR-15
12-MAR-15
13-MAR-15
14-MAR-15
15-MAR-15
16-MAR-15
17-MAR-15
18-MAR-15
19-MAR-15
20-MAR-15
21-MAR-15
22-MAR-15
23-MAR-15
24-MAR-15
25-MAR-15
26-MAR-15
27-MAR-15
28-MAR-15
29-MAR-15
30-MAR-15
31-MAR-15
01-APR-15
02-APR-15
03-APR-15
04-APR-15
05-APR-15
06-APR-15
07-APR-15
08-APR-15
09-APR-15
10-APR-15
11-APR-15
12-APR-15
13-APR-15
14-APR-15
15-APR-15
16-APR-15
17-APR-15
18-APR-15
19-APR-15
20-APR-15
21-APR-15
22-APR-15
23-APR-15
24-APR-15
25-APR-15
26-APR-15
27-APR-15
28-APR-15
29-APR-15
30-APR-15
01-MAY-15
02-MAY-15
03-MAY-15
04-MAY-15
05-MAY-15
06-MAY-15
07-MAY-15
08-MAY-15
09-MAY-15
10-MAY-15
11-MAY-15
12-MAY-15
13-MAY-15
14-MAY-15
15-MAY-15
16-MAY-15
17-MAY-15
18-MAY-15
19-MAY-15
20-MAY-15
21-MAY-15
22-MAY-15
23-MAY-15
24-MAY-15
25-MAY-15
26-MAY-15
27-MAY-15
28-MAY-15
29-MAY-15
30-MAY-15
31-MAY-15
01-JUN-15
02-JUN-15
03-JUN-15
04-JUN-15
05-JUN-15
06-JUN-15
07-JUN-15
08-JUN-15
09-JUN-15
10-JUN-15
11-JUN-15
12-JUN-15
13-JUN-15
14-JUN-15
15-JUN-15
16-JUN-15
17-JUN-15
18-JUN-15
19-JUN-15
20-JUN-15
21-JUN-15
22-JUN-15
23-JUN-15
24-JUN-15
25-JUN-15
26-JUN-15
27-JUN-15
28-JUN-15
29-JUN-15
30-JUN-15
01-JUL-15
02-JUL-15
03-JUL-15
04-JUL-15
05-JUL-15
06-JUL-15
07-JUL-15
08-JUL-15
09-JUL-15
10-JUL-15
11-JUL-15
12-JUL-15
13-JUL-15
14-JUL-15
15-JUL-15
16-JUL-15
17-JUL-15
18-JUL-15
19-JUL-15
20-JUL-15
21-JUL-15
22-JUL-15
23-JUL-15
24-JUL-15
25-JUL-15
26-JUL-15
27-JUL-15
28-JUL-15
29-JUL-15
30-JUL-15
31-JUL-15
01-AUG-15
02-AUG-15
03-AUG-15
04-AUG-15
05-AUG-15
06-AUG-15
07-AUG-15
08-AUG-15
09-AUG-15
10-AUG-15
11-AUG-15
12-AUG-15
13-AUG-15
14-AUG-15
15-AUG-15
16-AUG-15
17-AUG-15
18-AUG-15
19-AUG-15
20-AUG-15
21-AUG-15
22-AUG-15
23-AUG-15
24-AUG-15
25-AUG-15
26-AUG-15
27-AUG-15
28-AUG-15
29-AUG-15
30-AUG-15
31-AUG-15
01-SEP-15
02-SEP-15
03-SEP-15
04-SEP-15
05-SEP-15
06-SEP-15
07-SEP-15
08-SEP-15
09-SEP-15
10-SEP-15
11-SEP-15
12-SEP-15
13-SEP-15
14-SEP-15
15-SEP-15
16-SEP-15
17-SEP-15
18-SEP-15
19-SEP-15
20-SEP-15
21-SEP-15
22-SEP-15
23-SEP-15
24-SEP-15
25-SEP-15
26-SEP-15
27-SEP-15
28-SEP-15
29-SEP-15
30-SEP-15
01-OCT-15
02-OCT-15
03-OCT-15
04-OCT-15
05-OCT-15
06-OCT-15
07-OCT-15
08-OCT-15
09-OCT-15
10-OCT-15
11-OCT-15
12-OCT-15
13-OCT-15
14-OCT-15
15-OCT-15
16-OCT-15
17-OCT-15
18-OCT-15
19-OCT-15
20-OCT-15
21-OCT-15
22-OCT-15
23-OCT-15
24-OCT-15
25-OCT-15
26-OCT-15
27-OCT-15
28-OCT-15
29-OCT-15
30-OCT-15
31-OCT-15
01-NOV-15
02-NOV-15
03-NOV-15
04-NOV-15
05-NOV-15
06-NOV-15
07-NOV-15
08-NOV-15
09-NOV-15
10-NOV-15
11-NOV-15
12-NOV-15
13-NOV-15
14-NOV-15
15-NOV-15
16-NOV-15
17-NOV-15
18-NOV-15
19-NOV-15
20-NOV-15
21-NOV-15
22-NOV-15
23-NOV-15
24-NOV-15
25-NOV-15
26-NOV-15
27-NOV-15
28-NOV-15
29-NOV-15
30-NOV-15
01-DEC-15
02-DEC-15
03-DEC-15
04-DEC-15
05-DEC-15
06-DEC-15
07-DEC-15
08-DEC-15
09-DEC-15
10-DEC-15
11-DEC-15
12-DEC-15
13-DEC-15
14-DEC-15
15-DEC-15
16-DEC-15
17-DEC-15
18-DEC-15
19-DEC-15
20-DEC-15
21-DEC-15
22-DEC-15
23-DEC-15
24-DEC-15
25-DEC-15
26-DEC-15
27-DEC-15
28-DEC-15
29-DEC-15
30-DEC-15
31-DEC-15
01-JAN-16
02-JAN-16
03-JAN-16
04-JAN-16
05-JAN-16
06-JAN-16
07-JAN-16
08-JAN-16
09-JAN-16
10-JAN-16
11-JAN-16
12-JAN-16
13-JAN-16
14-JAN-16
15-JAN-16
16-JAN-16
17-JAN-16
18-JAN-16
19-JAN-16
20-JAN-16
21-JAN-16
22-JAN-16
23-JAN-16
24-JAN-16
25-JAN-16
26-JAN-16
27-JAN-16
28-JAN-16
29-JAN-16
30-JAN-16
31-JAN-16
01-FEB-16
02-FEB-16
03-FEB-16
04-FEB-16
05-FEB-16
06-FEB-16
07-FEB-16
08-FEB-16
09-FEB-16
10-FEB-16
11-FEB-16
12-FEB-16
13-FEB-16
14-FEB-16
15-FEB-16
16-FEB-16
17-FEB-16
18-FEB-16
19-FEB-16
20-FEB-16
21-FEB-16
22-FEB-16
23-FEB-16
24-FEB-16
25-FEB-16
26-FEB-16
27-FEB-16
28-FEB-16
29-FEB-16
01-MAR-16
02-MAR-16
03-MAR-16
04-MAR-16
05-MAR-16
06-MAR-16
07-MAR-16
08-MAR-16
09-MAR-16
10-MAR-16
11-MAR-16
12-MAR-16
13-MAR-16
14-MAR-16
15-MAR-16
16-MAR-16
17-MAR-16
18-MAR-16
19-MAR-16
20-MAR-16
21-MAR-16
22-MAR-16
23-MAR-16
24-MAR-16
25-MAR-16
26-MAR-16
27-MAR-16
28-MAR-16
29-MAR-16
30-MAR-16
31-MAR-16
01-APR-16
02-APR-16
03-APR-16
04-APR-16
05-APR-16
06-APR-16
07-APR-16
08-APR-16
09-APR-16
10-APR-16
11-APR-16
12-APR-16
13-APR-16
14-APR-16
15-APR-16
16-APR-16
17-APR-16
18-APR-16
19-APR-16
20-APR-16
21-APR-16
22-APR-16
23-APR-16
24-APR-16
25-APR-16
26-APR-16
27-APR-16
28-APR-16
29-APR-16
30-APR-16
01-MAY-16
02-MAY-16
03-MAY-16
04-MAY-16
05-MAY-16
06-MAY-16
07-MAY-16
08-MAY-16
09-MAY-16
10-MAY-16
11-MAY-16
12-MAY-16
13-MAY-16
14-MAY-16
15-MAY-16
16-MAY-16
17-MAY-16
18-MAY-16
19-MAY-16
20-MAY-16
21-MAY-16
22-MAY-16
23-MAY-16
24-MAY-16
25-MAY-16
26-MAY-16
27-MAY-16
28-MAY-16
29-MAY-16
30-MAY-16
31-MAY-16
01-JUN-16
02-JUN-16
03-JUN-16
04-JUN-16
05-JUN-16
06-JUN-16
07-JUN-16
08-JUN-16
09-JUN-16
10-JUN-16
11-JUN-16
12-JUN-16
13-JUN-16
14-JUN-16
15-JUN-16
16-JUN-16
17-JUN-16
18-JUN-16
19-JUN-16
20-JUN-16
21-JUN-16
22-JUN-16
23-JUN-16
24-JUN-16
25-JUN-16
26-JUN-16
27-JUN-16
28-JUN-16
29-JUN-16
30-JUN-16
01-JUL-16
02-JUL-16
03-JUL-16
04-JUL-16
05-JUL-16
06-JUL-16
07-JUL-16
08-JUL-16
09-JUL-16
10-JUL-16
11-JUL-16
12-JUL-16
13-JUL-16
14-JUL-16
15-JUL-16
16-JUL-16
17-JUL-16
18-JUL-16
19-JUL-16
20-JUL-16
21-JUL-16
22-JUL-16
23-JUL-16
24-JUL-16
25-JUL-16
26-JUL-16
27-JUL-16
28-JUL-16
29-JUL-16
30-JUL-16
31-JUL-16
01-AUG-16
02-AUG-16
03-AUG-16
04-AUG-16
05-AUG-16
06-AUG-16
07-AUG-16
08-AUG-16
09-AUG-16
10-AUG-16
11-AUG-16
12-AUG-16
13-AUG-16
14-AUG-16
15-AUG-16
16-AUG-16
17-AUG-16
18-AUG-16
19-AUG-16
20-AUG-16
21-AUG-16
22-AUG-16
23-AUG-16
24-AUG-16
25-AUG-16
26-AUG-16
27-AUG-16
28-AUG-16
29-AUG-16
30-AUG-16
31-AUG-16
01-SEP-16
02-SEP-16
03-SEP-16
04-SEP-16
05-SEP-16
06-SEP-16
07-SEP-16
08-SEP-16
09-SEP-16
10-SEP-16
11-SEP-16
12-SEP-16
13-SEP-16
14-SEP-16
15-SEP-16
16-SEP-16
17-SEP-16
18-SEP-16
19-SEP-16
20-SEP-16
21-SEP-16
22-SEP-16
23-SEP-16
24-SEP-16
25-SEP-16
26-SEP-16
27-SEP-16
28-SEP-16
29-SEP-16
30-SEP-16
01-OCT-16
02-OCT-16
03-OCT-16
04-OCT-16
05-OCT-16
06-OCT-16
07-OCT-16
08-OCT-16
09-OCT-16
10-OCT-16
11-OCT-16
12-OCT-16
13-OCT-16
14-OCT-16
15-OCT-16
16-OCT-16
17-OCT-16
18-OCT-16
19-OCT-16
20-OCT-16
21-OCT-16
22-OCT-16
23-OCT-16
24-OCT-16
25-OCT-16
26-OCT-16
27-OCT-16
28-OCT-16
29-OCT-16
30-OCT-16
31-OCT-16
01-NOV-16
02-NOV-16
03-NOV-16
04-NOV-16
05-NOV-16
06-NOV-16
07-NOV-16
08-NOV-16
09-NOV-16
10-NOV-16
11-NOV-16
12-NOV-16
13-NOV-16
14-NOV-16
15-NOV-16
16-NOV-16
17-NOV-16
18-NOV-16
19-NOV-16
20-NOV-16
21-NOV-16
22-NOV-16
23-NOV-16
24-NOV-16
25-NOV-16
26-NOV-16
27-NOV-16
28-NOV-16
29-NOV-16
30-NOV-16
01-DEC-16
02-DEC-16
03-DEC-16
04-DEC-16
05-DEC-16
06-DEC-16
07-DEC-16
08-DEC-16
09-DEC-16
10-DEC-16
11-DEC-16
12-DEC-16
13-DEC-16
14-DEC-16
15-DEC-16
16-DEC-16
17-DEC-16
18-DEC-16
19-DEC-16
20-DEC-16
21-DEC-16
22-DEC-16
23-DEC-16
24-DEC-16
25-DEC-16
26-DEC-16
27-DEC-16
28-DEC-16
29-DEC-16
30-DEC-16
31-DEC-16
01-JAN-17
02-JAN-17
03-JAN-17
04-JAN-17
05-JAN-17
06-JAN-17
07-JAN-17
08-JAN-17
09-JAN-17
10-JAN-17
11-JAN-17
12-JAN-17
13-JAN-17
14-JAN-17
15-JAN-17
16-JAN-17
17-JAN-17
18-JAN-17
19-JAN-17
20-JAN-17
21-JAN-17
22-JAN-17
23-JAN-17
24-JAN-17
25-JAN-17
26-JAN-17
27-JAN-17
28-JAN-17
29-JAN-17
30-JAN-17
31-JAN-17
01-FEB-17
02-FEB-17
03-FEB-17
04-FEB-17
05-FEB-17
06-FEB-17
07-FEB-17
08-FEB-17
09-FEB-17
10-FEB-17
11-FEB-17
12-FEB-17
13-FEB-17
14-FEB-17
15-FEB-17
16-FEB-17
17-FEB-17
18-FEB-17
19-FEB-17
20-FEB-17
21-FEB-17
22-FEB-17
23-FEB-17
24-FEB-17
25-FEB-17
26-FEB-17
27-FEB-17
28-FEB-17
01-MAR-17
02-MAR-17
03-MAR-17
04-MAR-17
05-MAR-17
06-MAR-17
07-MAR-17
08-MAR-17
09-MAR-17
10-MAR-17
11-MAR-17
12-MAR-17
13-MAR-17
14-MAR-17
15-MAR-17
16-MAR-17
17-MAR-17
18-MAR-17
19-MAR-17
20-MAR-17
21-MAR-17
22-MAR-17
23-MAR-17
24-MAR-17
25-MAR-17
26-MAR-17
27-MAR-17
28-MAR-17
29-MAR-17
30-MAR-17
31-MAR-17
01-APR-17
02-APR-17
03-APR-17
04-APR-17
05-APR-17
06-APR-17
07-APR-17
08-APR-17
09-APR-17
10-APR-17
11-APR-17
12-APR-17
13-APR-17
14-APR-17
15-APR-17
16-APR-17
17-APR-17
18-APR-17
19-APR-17
20-APR-17
21-APR-17
22-APR-17
23-APR-17
24-APR-17
25-APR-17
26-APR-17
27-APR-17
28-APR-17
29-APR-17
30-APR-17
01-MAY-17
02-MAY-17
03-MAY-17
04-MAY-17
05-MAY-17
06-MAY-17
07-MAY-17
08-MAY-17
09-MAY-17
10-MAY-17
11-MAY-17
12-MAY-17
13-MAY-17
14-MAY-17
15-MAY-17
16-MAY-17
17-MAY-17
18-MAY-17
19-MAY-17
20-MAY-17
21-MAY-17
22-MAY-17
23-MAY-17
24-MAY-17
25-MAY-17
26-MAY-17
27-MAY-17
28-MAY-17
29-MAY-17
30-MAY-17
31-MAY-17
01-JUN-17
02-JUN-17
03-JUN-17
04-JUN-17
05-JUN-17
06-JUN-17
07-JUN-17
08-JUN-17
09-JUN-17
10-JUN-17
11-JUN-17
12-JUN-17
13-JUN-17
14-JUN-17
15-JUN-17
16-JUN-17
17-JUN-17
18-JUN-17
19-JUN-17
20-JUN-17
21-JUN-17
22-JUN-17
23-JUN-17
24-JUN-17
25-JUN-17
26-JUN-17
27-JUN-17
28-JUN-17
29-JUN-17
30-JUN-17
01-JUL-17
02-JUL-17
03-JUL-17
04-JUL-17
05-JUL-17
06-JUL-17
07-JUL-17
08-JUL-17
09-JUL-17
10-JUL-17
11-JUL-17
12-JUL-17
13-JUL-17
14-JUL-17
15-JUL-17
16-JUL-17
17-JUL-17
18-JUL-17
19-JUL-17
20-JUL-17
21-JUL-17
22-JUL-17
23-JUL-17
24-JUL-17
25-JUL-17
26-JUL-17
27-JUL-17
28-JUL-17
29-JUL-17
30-JUL-17
31-JUL-17
01-AUG-17
02-AUG-17
03-AUG-17
04-AUG-17
05-AUG-17
06-AUG-17
07-AUG-17
08-AUG-17
09-AUG-17
10-AUG-17
11-AUG-17
12-AUG-17
13-AUG-17
14-AUG-17
15-AUG-17
16-AUG-17
17-AUG-17
18-AUG-17
19-AUG-17
20-AUG-17
21-AUG-17
22-AUG-17
23-AUG-17
24-AUG-17
25-AUG-17
26-AUG-17
27-AUG-17
28-AUG-17
29-AUG-17
30-AUG-17
31-AUG-17
01-SEP-17
02-SEP-17
03-SEP-17
04-SEP-17
05-SEP-17
06-SEP-17
07-SEP-17
08-SEP-17
09-SEP-17
10-SEP-17
11-SEP-17
12-SEP-17
13-SEP-17
14-SEP-17
15-SEP-17
16-SEP-17
17-SEP-17
18-SEP-17
19-SEP-17
20-SEP-17
21-SEP-17
22-SEP-17
23-SEP-17
24-SEP-17
25-SEP-17
26-SEP-17
27-SEP-17
28-SEP-17
29-SEP-17
30-SEP-17
01-OCT-17
02-OCT-17
03-OCT-17
04-OCT-17
05-OCT-17
06-OCT-17
07-OCT-17
08-OCT-17
09-OCT-17
10-OCT-17
11-OCT-17
12-OCT-17
13-OCT-17
14-OCT-17
15-OCT-17
16-OCT-17
17-OCT-17
18-OCT-17
19-OCT-17
20-OCT-17
21-OCT-17
22-OCT-17
23-OCT-17
24-OCT-17
25-OCT-17
26-OCT-17
27-OCT-17
28-OCT-17
29-OCT-17
30-OCT-17
31-OCT-17
01-NOV-17
02-NOV-17
03-NOV-17
04-NOV-17
05-NOV-17
06-NOV-17
07-NOV-17
08-NOV-17
09-NOV-17
10-NOV-17
11-NOV-17
12-NOV-17
13-NOV-17
14-NOV-17
15-NOV-17
16-NOV-17
17-NOV-17
18-NOV-17
19-NOV-17
20-NOV-17
21-NOV-17
22-NOV-17
23-NOV-17
24-NOV-17
25-NOV-17
26-NOV-17
27-NOV-17
28-NOV-17
29-NOV-17
30-NOV-17
01-DEC-17
02-DEC-17
03-DEC-17
04-DEC-17
05-DEC-17
06-DEC-17
07-DEC-17
08-DEC-17
09-DEC-17
10-DEC-17
11-DEC-17
12-DEC-17
13-DEC-17
14-DEC-17
15-DEC-17
16-DEC-17
17-DEC-17
18-DEC-17
19-DEC-17
20-DEC-17
21-DEC-17
22-DEC-17
23-DEC-17
24-DEC-17
25-DEC-17
26-DEC-17
27-DEC-17
28-DEC-17
29-DEC-17
30-DEC-17
31-DEC-17
01-JAN-18
02-JAN-18
03-JAN-18
04-JAN-18
05-JAN-18
06-JAN-18
07-JAN-18
08-JAN-18
09-JAN-18
10-JAN-18
11-JAN-18
12-JAN-18
13-JAN-18
14-JAN-18
15-JAN-18
16-JAN-18
17-JAN-18
18-JAN-18
19-JAN-18
20-JAN-18

1826 rows selected.

CAL_DATE
21-JAN-18
22-JAN-18
23-JAN-18
24-JAN-18
25-JAN-18
26-JAN-18
27-JAN-18
28-JAN-18
29-JAN-18
30-JAN-18
31-JAN-18
01-FEB-18
02-FEB-18
03-FEB-18
04-FEB-18
05-FEB-18
06-FEB-18
07-FEB-18
08-FEB-18
09-FEB-18
10-FEB-18
11-FEB-18
12-FEB-18
13-FEB-18
14-FEB-18
15-FEB-18
16-FEB-18
17-FEB-18
18-FEB-18
19-FEB-18
20-FEB-18
21-FEB-18
22-FEB-18
23-FEB-18
24-FEB-18
25-FEB-18
26-FEB-18
27-FEB-18
28-FEB-18
01-MAR-18
02-MAR-18
03-MAR-18
04-MAR-18
05-MAR-18
06-MAR-18
07-MAR-18
08-MAR-18
09-MAR-18
10-MAR-18
11-MAR-18
12-MAR-18
13-MAR-18
14-MAR-18
15-MAR-18
16-MAR-18
17-MAR-18
18-MAR-18
19-MAR-18
20-MAR-18
21-MAR-18
22-MAR-18
23-MAR-18
24-MAR-18
25-MAR-18
26-MAR-18
27-MAR-18
28-MAR-18
29-MAR-18
30-MAR-18
31-MAR-18
01-APR-18
02-APR-18
03-APR-18
04-APR-18
05-APR-18
06-APR-18
07-APR-18
08-APR-18
09-APR-18
10-APR-18
11-APR-18
12-APR-18
13-APR-18
14-APR-18
15-APR-18
16-APR-18
17-APR-18
18-APR-18
19-APR-18
20-APR-18
21-APR-18
22-APR-18
23-APR-18
24-APR-18
25-APR-18
26-APR-18
27-APR-18
28-APR-18
29-APR-18
30-APR-18
01-MAY-18
02-MAY-18
03-MAY-18
04-MAY-18
05-MAY-18
06-MAY-18
07-MAY-18
08-MAY-18
09-MAY-18
10-MAY-18
11-MAY-18
12-MAY-18
13-MAY-18
14-MAY-18
15-MAY-18
16-MAY-18
17-MAY-18
18-MAY-18
19-MAY-18
20-MAY-18
21-MAY-18
22-MAY-18
23-MAY-18
24-MAY-18
25-MAY-18
26-MAY-18
27-MAY-18
28-MAY-18
29-MAY-18
30-MAY-18
31-MAY-18
01-JUN-18
02-JUN-18
03-JUN-18
04-JUN-18
05-JUN-18
06-JUN-18
07-JUN-18
08-JUN-18
09-JUN-18
10-JUN-18
11-JUN-18
12-JUN-18
13-JUN-18
14-JUN-18
15-JUN-18
16-JUN-18
17-JUN-18
18-JUN-18
19-JUN-18
20-JUN-18
21-JUN-18
22-JUN-18
23-JUN-18
24-JUN-18
25-JUN-18
26-JUN-18
27-JUN-18
28-JUN-18
29-JUN-18
30-JUN-18
01-JUL-18
02-JUL-18
03-JUL-18
04-JUL-18
05-JUL-18
06-JUL-18
07-JUL-18
08-JUL-18
09-JUL-18
10-JUL-18
11-JUL-18
12-JUL-18
13-JUL-18
14-JUL-18
15-JUL-18
16-JUL-18
17-JUL-18
18-JUL-18
19-JUL-18
20-JUL-18
21-JUL-18
22-JUL-18
23-JUL-18
24-JUL-18
25-JUL-18
26-JUL-18
27-JUL-18
28-JUL-18
29-JUL-18
30-JUL-18
31-JUL-18
01-AUG-18
02-AUG-18
03-AUG-18
04-AUG-18
05-AUG-18
06-AUG-18
07-AUG-18
08-AUG-18
09-AUG-18
10-AUG-18
11-AUG-18
12-AUG-18
13-AUG-18
14-AUG-18
15-AUG-18
16-AUG-18
17-AUG-18
18-AUG-18
19-AUG-18
20-AUG-18
21-AUG-18
22-AUG-18
23-AUG-18
24-AUG-18
25-AUG-18
26-AUG-18
27-AUG-18
28-AUG-18
29-AUG-18
30-AUG-18
31-AUG-18
01-SEP-18
02-SEP-18
03-SEP-18
04-SEP-18
05-SEP-18
06-SEP-18
07-SEP-18
08-SEP-18
09-SEP-18
10-SEP-18
11-SEP-18
12-SEP-18
13-SEP-18
14-SEP-18
15-SEP-18
16-SEP-18
17-SEP-18
18-SEP-18
19-SEP-18
20-SEP-18
21-SEP-18
22-SEP-18
23-SEP-18
24-SEP-18
25-SEP-18
26-SEP-18
27-SEP-18
28-SEP-18
29-SEP-18
30-SEP-18
01-OCT-18
02-OCT-18
03-OCT-18
04-OCT-18
05-OCT-18
06-OCT-18
07-OCT-18
08-OCT-18
09-OCT-18
10-OCT-18
11-OCT-18
12-OCT-18
13-OCT-18
14-OCT-18
15-OCT-18
16-OCT-18
17-OCT-18
18-OCT-18
19-OCT-18
20-OCT-18
21-OCT-18
22-OCT-18
23-OCT-18
24-OCT-18
25-OCT-18
26-OCT-18
27-OCT-18
28-OCT-18
29-OCT-18
30-OCT-18
31-OCT-18
01-NOV-18
02-NOV-18
03-NOV-18
04-NOV-18
05-NOV-18
06-NOV-18
07-NOV-18
08-NOV-18
09-NOV-18
10-NOV-18
11-NOV-18
12-NOV-18
13-NOV-18
14-NOV-18
15-NOV-18
16-NOV-18
17-NOV-18
18-NOV-18
19-NOV-18
20-NOV-18
21-NOV-18
22-NOV-18
23-NOV-18
24-NOV-18
25-NOV-18
26-NOV-18
27-NOV-18
28-NOV-18
29-NOV-18
30-NOV-18
01-DEC-18
02-DEC-18
03-DEC-18
04-DEC-18
05-DEC-18
06-DEC-18
07-DEC-18
08-DEC-18
09-DEC-18
10-DEC-18
11-DEC-18
12-DEC-18
13-DEC-18
14-DEC-18
15-DEC-18
16-DEC-18
17-DEC-18
18-DEC-18
19-DEC-18
20-DEC-18
21-DEC-18
22-DEC-18
23-DEC-18
24-DEC-18
25-DEC-18
26-DEC-18
27-DEC-18
28-DEC-18
29-DEC-18
30-DEC-18
31-DEC-18
01-JAN-19
02-JAN-19
03-JAN-19
04-JAN-19
05-JAN-19
06-JAN-19
07-JAN-19
08-JAN-19
09-JAN-19
10-JAN-19
11-JAN-19
12-JAN-19
13-JAN-19
14-JAN-19
15-JAN-19
16-JAN-19
17-JAN-19
18-JAN-19
19-JAN-19
20-JAN-19
21-JAN-19
22-JAN-19
23-JAN-19
24-JAN-19
25-JAN-19
26-JAN-19
27-JAN-19
28-JAN-19
29-JAN-19
30-JAN-19
31-JAN-19
01-FEB-19
02-FEB-19
03-FEB-19
04-FEB-19
05-FEB-19
06-FEB-19
07-FEB-19
08-FEB-19
09-FEB-19
10-FEB-19
11-FEB-19
12-FEB-19
13-FEB-19
14-FEB-19
15-FEB-19
16-FEB-19
17-FEB-19
18-FEB-19
19-FEB-19
20-FEB-19
21-FEB-19
22-FEB-19
23-FEB-19
24-FEB-19
25-FEB-19
26-FEB-19
27-FEB-19
28-FEB-19
01-MAR-19
02-MAR-19
03-MAR-19
04-MAR-19
05-MAR-19
06-MAR-19
07-MAR-19
08-MAR-19
09-MAR-19
10-MAR-19
11-MAR-19
12-MAR-19
13-MAR-19
14-MAR-19
15-MAR-19
16-MAR-19
17-MAR-19
18-MAR-19
19-MAR-19
20-MAR-19
21-MAR-19
22-MAR-19
23-MAR-19
24-MAR-19
25-MAR-19
26-MAR-19
27-MAR-19
28-MAR-19
29-MAR-19
30-MAR-19
31-MAR-19
01-APR-19
02-APR-19
03-APR-19
04-APR-19
05-APR-19
06-APR-19
07-APR-19
08-APR-19
09-APR-19
10-APR-19
11-APR-19
12-APR-19
13-APR-19
14-APR-19
15-APR-19
16-APR-19
17-APR-19
18-APR-19
19-APR-19
20-APR-19
21-APR-19
22-APR-19
23-APR-19
24-APR-19
25-APR-19
26-APR-19
27-APR-19
28-APR-19
29-APR-19
30-APR-19
01-MAY-19
02-MAY-19
03-MAY-19
04-MAY-19
05-MAY-19
06-MAY-19
07-MAY-19
08-MAY-19
09-MAY-19
10-MAY-19
11-MAY-19
12-MAY-19
13-MAY-19
14-MAY-19
15-MAY-19
16-MAY-19
17-MAY-19
18-MAY-19
19-MAY-19
20-MAY-19
21-MAY-19
22-MAY-19
23-MAY-19
24-MAY-19
25-MAY-19
26-MAY-19
27-MAY-19
28-MAY-19
29-MAY-19
30-MAY-19
31-MAY-19
01-JUN-19
02-JUN-19
03-JUN-19
04-JUN-19

Statement 9

select  
    "CAL_DATE" 
from "TEST_CALENDAR" 
order by cal_date


CAL_DATE
01-JAN-15
02-JAN-15
03-JAN-15
04-JAN-15
05-JAN-15
06-JAN-15
07-JAN-15
08-JAN-15
09-JAN-15
10-JAN-15
11-JAN-15
12-JAN-15
13-JAN-15
14-JAN-15
15-JAN-15
16-JAN-15
17-JAN-15
18-JAN-15
19-JAN-15
20-JAN-15
21-JAN-15
22-JAN-15
23-JAN-15
24-JAN-15
25-JAN-15
26-JAN-15
27-JAN-15
28-JAN-15
29-JAN-15
30-JAN-15
31-JAN-15
01-FEB-15
02-FEB-15
03-FEB-15
04-FEB-15
05-FEB-15
06-FEB-15
07-FEB-15
08-FEB-15
09-FEB-15
10-FEB-15
11-FEB-15
12-FEB-15
13-FEB-15
14-FEB-15
15-FEB-15
16-FEB-15
17-FEB-15
18-FEB-15
19-FEB-15
20-FEB-15
21-FEB-15
22-FEB-15
23-FEB-15
24-FEB-15
25-FEB-15
26-FEB-15
27-FEB-15
28-FEB-15
01-MAR-15
02-MAR-15
03-MAR-15
04-MAR-15
05-MAR-15
06-MAR-15
07-MAR-15
08-MAR-15
09-MAR-15
10-MAR-15
11-MAR-15
12-MAR-15
13-MAR-15
14-MAR-15
15-MAR-15
16-MAR-15
17-MAR-15
18-MAR-15
19-MAR-15
20-MAR-15
21-MAR-15
22-MAR-15
23-MAR-15
24-MAR-15
25-MAR-15
26-MAR-15
27-MAR-15
28-MAR-15
29-MAR-15
30-MAR-15
31-MAR-15
01-APR-15
02-APR-15
03-APR-15
04-APR-15
05-APR-15
06-APR-15
07-APR-15
08-APR-15
09-APR-15
10-APR-15
11-APR-15
12-APR-15
13-APR-15
14-APR-15
15-APR-15
16-APR-15
17-APR-15
18-APR-15
19-APR-15
20-APR-15
21-APR-15
22-APR-15
23-APR-15
24-APR-15
25-APR-15
26-APR-15
27-APR-15
28-APR-15
29-APR-15
30-APR-15
01-MAY-15
02-MAY-15
03-MAY-15
04-MAY-15
05-MAY-15
06-MAY-15
07-MAY-15
08-MAY-15
09-MAY-15
10-MAY-15
11-MAY-15
12-MAY-15
13-MAY-15
14-MAY-15
15-MAY-15
16-MAY-15
17-MAY-15
18-MAY-15
19-MAY-15
20-MAY-15
21-MAY-15
22-MAY-15
23-MAY-15
24-MAY-15
25-MAY-15
26-MAY-15
27-MAY-15
28-MAY-15
29-MAY-15
30-MAY-15
31-MAY-15
01-JUN-15
02-JUN-15
03-JUN-15
04-JUN-15
05-JUN-15
06-JUN-15
07-JUN-15
08-JUN-15
09-JUN-15
10-JUN-15
11-JUN-15
12-JUN-15
13-JUN-15
14-JUN-15
15-JUN-15
16-JUN-15
17-JUN-15
18-JUN-15
19-JUN-15
20-JUN-15
21-JUN-15
22-JUN-15
23-JUN-15
24-JUN-15
25-JUN-15
26-JUN-15
27-JUN-15
28-JUN-15
29-JUN-15
30-JUN-15
01-JUL-15
02-JUL-15
03-JUL-15
04-JUL-15
05-JUL-15
06-JUL-15
07-JUL-15
08-JUL-15
09-JUL-15
10-JUL-15
11-JUL-15
12-JUL-15
13-JUL-15
14-JUL-15
15-JUL-15
16-JUL-15
17-JUL-15
18-JUL-15
19-JUL-15
20-JUL-15
21-JUL-15
22-JUL-15
23-JUL-15
24-JUL-15
25-JUL-15
26-JUL-15
27-JUL-15
28-JUL-15
29-JUL-15
30-JUL-15
31-JUL-15
01-AUG-15
02-AUG-15
03-AUG-15
04-AUG-15
05-AUG-15
06-AUG-15
07-AUG-15
08-AUG-15
09-AUG-15
10-AUG-15
11-AUG-15
12-AUG-15
13-AUG-15
14-AUG-15
15-AUG-15
16-AUG-15
17-AUG-15
18-AUG-15
19-AUG-15
20-AUG-15
21-AUG-15
22-AUG-15
23-AUG-15
24-AUG-15
25-AUG-15
26-AUG-15
27-AUG-15
28-AUG-15
29-AUG-15
30-AUG-15
31-AUG-15
01-SEP-15
02-SEP-15
03-SEP-15
04-SEP-15
05-SEP-15
06-SEP-15
07-SEP-15
08-SEP-15
09-SEP-15
10-SEP-15
11-SEP-15
12-SEP-15
13-SEP-15
14-SEP-15
15-SEP-15
16-SEP-15
17-SEP-15
18-SEP-15
19-SEP-15
20-SEP-15
21-SEP-15
22-SEP-15
23-SEP-15
24-SEP-15
25-SEP-15
26-SEP-15
27-SEP-15
28-SEP-15
29-SEP-15
30-SEP-15
01-OCT-15
02-OCT-15
03-OCT-15
04-OCT-15
05-OCT-15
06-OCT-15
07-OCT-15
08-OCT-15
09-OCT-15
10-OCT-15
11-OCT-15
12-OCT-15
13-OCT-15
14-OCT-15
15-OCT-15
16-OCT-15
17-OCT-15
18-OCT-15
19-OCT-15
20-OCT-15
21-OCT-15
22-OCT-15
23-OCT-15
24-OCT-15
25-OCT-15
26-OCT-15
27-OCT-15
28-OCT-15
29-OCT-15
30-OCT-15
31-OCT-15
01-NOV-15
02-NOV-15
03-NOV-15
04-NOV-15
05-NOV-15
06-NOV-15
07-NOV-15
08-NOV-15
09-NOV-15
10-NOV-15
11-NOV-15
12-NOV-15
13-NOV-15
14-NOV-15
15-NOV-15
16-NOV-15
17-NOV-15
18-NOV-15
19-NOV-15
20-NOV-15
21-NOV-15
22-NOV-15
23-NOV-15
24-NOV-15
25-NOV-15
26-NOV-15
27-NOV-15
28-NOV-15
29-NOV-15
30-NOV-15
01-DEC-15
02-DEC-15
03-DEC-15
04-DEC-15
05-DEC-15
06-DEC-15
07-DEC-15
08-DEC-15
09-DEC-15
10-DEC-15
11-DEC-15
12-DEC-15
13-DEC-15
14-DEC-15
15-DEC-15
16-DEC-15
17-DEC-15
18-DEC-15
19-DEC-15
20-DEC-15
21-DEC-15
22-DEC-15
23-DEC-15
24-DEC-15
25-DEC-15
26-DEC-15
27-DEC-15
28-DEC-15
29-DEC-15
30-DEC-15
31-DEC-15
01-JAN-16
02-JAN-16
03-JAN-16
04-JAN-16
05-JAN-16
06-JAN-16
07-JAN-16
08-JAN-16
09-JAN-16
10-JAN-16
11-JAN-16
12-JAN-16
13-JAN-16
14-JAN-16
15-JAN-16
16-JAN-16
17-JAN-16
18-JAN-16
19-JAN-16
20-JAN-16
21-JAN-16
22-JAN-16
23-JAN-16
24-JAN-16
25-JAN-16
26-JAN-16
27-JAN-16
28-JAN-16
29-JAN-16
30-JAN-16
31-JAN-16
01-FEB-16
02-FEB-16
03-FEB-16
04-FEB-16
05-FEB-16
06-FEB-16
07-FEB-16
08-FEB-16
09-FEB-16
10-FEB-16
11-FEB-16
12-FEB-16
13-FEB-16
14-FEB-16
15-FEB-16
16-FEB-16
17-FEB-16
18-FEB-16
19-FEB-16
20-FEB-16
21-FEB-16
22-FEB-16
23-FEB-16
24-FEB-16
25-FEB-16
26-FEB-16
27-FEB-16
28-FEB-16
29-FEB-16
01-MAR-16
02-MAR-16
03-MAR-16
04-MAR-16
05-MAR-16
06-MAR-16
07-MAR-16
08-MAR-16
09-MAR-16
10-MAR-16
11-MAR-16
12-MAR-16
13-MAR-16
14-MAR-16
15-MAR-16
16-MAR-16
17-MAR-16
18-MAR-16
19-MAR-16
20-MAR-16
21-MAR-16
22-MAR-16
23-MAR-16
24-MAR-16
25-MAR-16
26-MAR-16
27-MAR-16
28-MAR-16
29-MAR-16
30-MAR-16
31-MAR-16
01-APR-16
02-APR-16
03-APR-16
04-APR-16
05-APR-16
06-APR-16
07-APR-16
08-APR-16
09-APR-16
10-APR-16
11-APR-16
12-APR-16
13-APR-16
14-APR-16
15-APR-16
16-APR-16
17-APR-16
18-APR-16
19-APR-16
20-APR-16
21-APR-16
22-APR-16
23-APR-16
24-APR-16
25-APR-16
26-APR-16
27-APR-16
28-APR-16
29-APR-16
30-APR-16
01-MAY-16
02-MAY-16
03-MAY-16
04-MAY-16
05-MAY-16
06-MAY-16
07-MAY-16
08-MAY-16
09-MAY-16
10-MAY-16
11-MAY-16
12-MAY-16
13-MAY-16
14-MAY-16
15-MAY-16
16-MAY-16
17-MAY-16
18-MAY-16
19-MAY-16
20-MAY-16
21-MAY-16
22-MAY-16
23-MAY-16
24-MAY-16
25-MAY-16
26-MAY-16
27-MAY-16
28-MAY-16
29-MAY-16
30-MAY-16
31-MAY-16
01-JUN-16
02-JUN-16
03-JUN-16
04-JUN-16
05-JUN-16
06-JUN-16
07-JUN-16
08-JUN-16
09-JUN-16
10-JUN-16
11-JUN-16
12-JUN-16
13-JUN-16
14-JUN-16
15-JUN-16
16-JUN-16
17-JUN-16
18-JUN-16
19-JUN-16
20-JUN-16
21-JUN-16
22-JUN-16
23-JUN-16
24-JUN-16
25-JUN-16
26-JUN-16
27-JUN-16
28-JUN-16
29-JUN-16
30-JUN-16
01-JUL-16
02-JUL-16
03-JUL-16
04-JUL-16
05-JUL-16
06-JUL-16
07-JUL-16
08-JUL-16
09-JUL-16
10-JUL-16
11-JUL-16
12-JUL-16
13-JUL-16
14-JUL-16
15-JUL-16
16-JUL-16
17-JUL-16
18-JUL-16
19-JUL-16
20-JUL-16
21-JUL-16
22-JUL-16
23-JUL-16
24-JUL-16
25-JUL-16
26-JUL-16
27-JUL-16
28-JUL-16
29-JUL-16
30-JUL-16
31-JUL-16
01-AUG-16
02-AUG-16
03-AUG-16
04-AUG-16
05-AUG-16
06-AUG-16
07-AUG-16
08-AUG-16
09-AUG-16
10-AUG-16
11-AUG-16
12-AUG-16
13-AUG-16
14-AUG-16
15-AUG-16
16-AUG-16
17-AUG-16
18-AUG-16
19-AUG-16
20-AUG-16
21-AUG-16
22-AUG-16
23-AUG-16
24-AUG-16
25-AUG-16
26-AUG-16
27-AUG-16
28-AUG-16
29-AUG-16
30-AUG-16
31-AUG-16
01-SEP-16
02-SEP-16
03-SEP-16
04-SEP-16
05-SEP-16
06-SEP-16
07-SEP-16
08-SEP-16
09-SEP-16
10-SEP-16
11-SEP-16
12-SEP-16
13-SEP-16
14-SEP-16
15-SEP-16
16-SEP-16
17-SEP-16
18-SEP-16
19-SEP-16
20-SEP-16
21-SEP-16
22-SEP-16
23-SEP-16
24-SEP-16
25-SEP-16
26-SEP-16
27-SEP-16
28-SEP-16
29-SEP-16
30-SEP-16
01-OCT-16
02-OCT-16
03-OCT-16
04-OCT-16
05-OCT-16
06-OCT-16
07-OCT-16
08-OCT-16
09-OCT-16
10-OCT-16
11-OCT-16
12-OCT-16
13-OCT-16
14-OCT-16
15-OCT-16
16-OCT-16
17-OCT-16
18-OCT-16
19-OCT-16
20-OCT-16
21-OCT-16
22-OCT-16
23-OCT-16
24-OCT-16
25-OCT-16
26-OCT-16
27-OCT-16
28-OCT-16
29-OCT-16
30-OCT-16
31-OCT-16
01-NOV-16
02-NOV-16
03-NOV-16
04-NOV-16
05-NOV-16
06-NOV-16
07-NOV-16
08-NOV-16
09-NOV-16
10-NOV-16
11-NOV-16
12-NOV-16
13-NOV-16
14-NOV-16
15-NOV-16
16-NOV-16
17-NOV-16
18-NOV-16
19-NOV-16
20-NOV-16
21-NOV-16
22-NOV-16
23-NOV-16
24-NOV-16
25-NOV-16
26-NOV-16
27-NOV-16
28-NOV-16
29-NOV-16
30-NOV-16
01-DEC-16
02-DEC-16
03-DEC-16
04-DEC-16
05-DEC-16
06-DEC-16
07-DEC-16
08-DEC-16
09-DEC-16
10-DEC-16
11-DEC-16
12-DEC-16
13-DEC-16
14-DEC-16
15-DEC-16
16-DEC-16
17-DEC-16
18-DEC-16
19-DEC-16
20-DEC-16
21-DEC-16
22-DEC-16
23-DEC-16
24-DEC-16
25-DEC-16
26-DEC-16
27-DEC-16
28-DEC-16
29-DEC-16
30-DEC-16
31-DEC-16
01-JAN-17
02-JAN-17
03-JAN-17
04-JAN-17
05-JAN-17
06-JAN-17
07-JAN-17
08-JAN-17
09-JAN-17
10-JAN-17
11-JAN-17
12-JAN-17
13-JAN-17
14-JAN-17
15-JAN-17
16-JAN-17
17-JAN-17
18-JAN-17
19-JAN-17
20-JAN-17
21-JAN-17
22-JAN-17
23-JAN-17
24-JAN-17
25-JAN-17
26-JAN-17
27-JAN-17
28-JAN-17
29-JAN-17
30-JAN-17
31-JAN-17
01-FEB-17
02-FEB-17
03-FEB-17
04-FEB-17
05-FEB-17
06-FEB-17
07-FEB-17
08-FEB-17
09-FEB-17
10-FEB-17
11-FEB-17
12-FEB-17
13-FEB-17
14-FEB-17
15-FEB-17
16-FEB-17
17-FEB-17
18-FEB-17
19-FEB-17
20-FEB-17
21-FEB-17
22-FEB-17
23-FEB-17
24-FEB-17
25-FEB-17
26-FEB-17
27-FEB-17
28-FEB-17
01-MAR-17
02-MAR-17
03-MAR-17
04-MAR-17
05-MAR-17
06-MAR-17
07-MAR-17
08-MAR-17
09-MAR-17
10-MAR-17
11-MAR-17
12-MAR-17
13-MAR-17
14-MAR-17
15-MAR-17
16-MAR-17
17-MAR-17
18-MAR-17
19-MAR-17
20-MAR-17
21-MAR-17
22-MAR-17
23-MAR-17
24-MAR-17
25-MAR-17
26-MAR-17
27-MAR-17
28-MAR-17
29-MAR-17
30-MAR-17
31-MAR-17
01-APR-17
02-APR-17
03-APR-17
04-APR-17
05-APR-17
06-APR-17
07-APR-17
08-APR-17
09-APR-17
10-APR-17
11-APR-17
12-APR-17
13-APR-17
14-APR-17
15-APR-17
16-APR-17
17-APR-17
18-APR-17
19-APR-17
20-APR-17
21-APR-17
22-APR-17
23-APR-17
24-APR-17
25-APR-17
26-APR-17
27-APR-17
28-APR-17
29-APR-17
30-APR-17
01-MAY-17
02-MAY-17
03-MAY-17
04-MAY-17
05-MAY-17
06-MAY-17
07-MAY-17
08-MAY-17
09-MAY-17
10-MAY-17
11-MAY-17
12-MAY-17
13-MAY-17
14-MAY-17
15-MAY-17
16-MAY-17
17-MAY-17
18-MAY-17
19-MAY-17
20-MAY-17
21-MAY-17
22-MAY-17
23-MAY-17
24-MAY-17
25-MAY-17
26-MAY-17
27-MAY-17
28-MAY-17
29-MAY-17
30-MAY-17
31-MAY-17
01-JUN-17
02-JUN-17
03-JUN-17
04-JUN-17
05-JUN-17
06-JUN-17
07-JUN-17
08-JUN-17
09-JUN-17
10-JUN-17
11-JUN-17
12-JUN-17
13-JUN-17
14-JUN-17
15-JUN-17
16-JUN-17
17-JUN-17
18-JUN-17
19-JUN-17
20-JUN-17
21-JUN-17
22-JUN-17
23-JUN-17
24-JUN-17
25-JUN-17
26-JUN-17
27-JUN-17
28-JUN-17
29-JUN-17
30-JUN-17
01-JUL-17
02-JUL-17
03-JUL-17
04-JUL-17
05-JUL-17
06-JUL-17
07-JUL-17
08-JUL-17
09-JUL-17
10-JUL-17
11-JUL-17
12-JUL-17
13-JUL-17
14-JUL-17
15-JUL-17
16-JUL-17
17-JUL-17
18-JUL-17
19-JUL-17
20-JUL-17
21-JUL-17
22-JUL-17
23-JUL-17
24-JUL-17
25-JUL-17
26-JUL-17
27-JUL-17
28-JUL-17
29-JUL-17
30-JUL-17
31-JUL-17
01-AUG-17
02-AUG-17
03-AUG-17
04-AUG-17
05-AUG-17
06-AUG-17
07-AUG-17
08-AUG-17
09-AUG-17
10-AUG-17
11-AUG-17
12-AUG-17
13-AUG-17
14-AUG-17
15-AUG-17
16-AUG-17
17-AUG-17
18-AUG-17
19-AUG-17
20-AUG-17
21-AUG-17
22-AUG-17
23-AUG-17
24-AUG-17
25-AUG-17
26-AUG-17
27-AUG-17
28-AUG-17
29-AUG-17
30-AUG-17
31-AUG-17
01-SEP-17
02-SEP-17
03-SEP-17
04-SEP-17
05-SEP-17
06-SEP-17
07-SEP-17
08-SEP-17
09-SEP-17
10-SEP-17
11-SEP-17
12-SEP-17
13-SEP-17
14-SEP-17
15-SEP-17
16-SEP-17
17-SEP-17
18-SEP-17
19-SEP-17
20-SEP-17
21-SEP-17
22-SEP-17
23-SEP-17
24-SEP-17
25-SEP-17
26-SEP-17
27-SEP-17
28-SEP-17
29-SEP-17
30-SEP-17
01-OCT-17
02-OCT-17
03-OCT-17
04-OCT-17
05-OCT-17
06-OCT-17
07-OCT-17
08-OCT-17
09-OCT-17
10-OCT-17
11-OCT-17
12-OCT-17
13-OCT-17
14-OCT-17
15-OCT-17
16-OCT-17
17-OCT-17
18-OCT-17
19-OCT-17
20-OCT-17
21-OCT-17
22-OCT-17
23-OCT-17
24-OCT-17
25-OCT-17
26-OCT-17
27-OCT-17
28-OCT-17
29-OCT-17
30-OCT-17
31-OCT-17
01-NOV-17
02-NOV-17
03-NOV-17
04-NOV-17
05-NOV-17
06-NOV-17
07-NOV-17
08-NOV-17
09-NOV-17
10-NOV-17
11-NOV-17
12-NOV-17
13-NOV-17
14-NOV-17
15-NOV-17
16-NOV-17
17-NOV-17
18-NOV-17
19-NOV-17
20-NOV-17
21-NOV-17
22-NOV-17
23-NOV-17
24-NOV-17
25-NOV-17
26-NOV-17
27-NOV-17
28-NOV-17
29-NOV-17
30-NOV-17
01-DEC-17
02-DEC-17
03-DEC-17
04-DEC-17
05-DEC-17
06-DEC-17
07-DEC-17
08-DEC-17
09-DEC-17
10-DEC-17
11-DEC-17
12-DEC-17
13-DEC-17
14-DEC-17
15-DEC-17
16-DEC-17
17-DEC-17
18-DEC-17
19-DEC-17
20-DEC-17
21-DEC-17
22-DEC-17
23-DEC-17
24-DEC-17
25-DEC-17
26-DEC-17
27-DEC-17
28-DEC-17
29-DEC-17
30-DEC-17
31-DEC-17
01-JAN-18
02-JAN-18
03-JAN-18
04-JAN-18
05-JAN-18
06-JAN-18
07-JAN-18
08-JAN-18
09-JAN-18
10-JAN-18
11-JAN-18
12-JAN-18
13-JAN-18
14-JAN-18
15-JAN-18
16-JAN-18
17-JAN-18
18-JAN-18
19-JAN-18
20-JAN-18
21-JAN-18
22-JAN-18
23-JAN-18
24-JAN-18
25-JAN-18
26-JAN-18
27-JAN-18
28-JAN-18
29-JAN-18
30-JAN-18
31-JAN-18
01-FEB-18
02-FEB-18
03-FEB-18
04-FEB-18
05-FEB-18
06-FEB-18
07-FEB-18
08-FEB-18
09-FEB-18
10-FEB-18
11-FEB-18
12-FEB-18
13-FEB-18
14-FEB-18
15-FEB-18
16-FEB-18
17-FEB-18
18-FEB-18
19-FEB-18
20-FEB-18
21-FEB-18
22-FEB-18
23-FEB-18
24-FEB-18
25-FEB-18
26-FEB-18
27-FEB-18
28-FEB-18
01-MAR-18
02-MAR-18
03-MAR-18
04-MAR-18
05-MAR-18
06-MAR-18
07-MAR-18
08-MAR-18
09-MAR-18
10-MAR-18
11-MAR-18
12-MAR-18
13-MAR-18
14-MAR-18
15-MAR-18
16-MAR-18
17-MAR-18
18-MAR-18
19-MAR-18
20-MAR-18
21-MAR-18
22-MAR-18
23-MAR-18
24-MAR-18
25-MAR-18
26-MAR-18
27-MAR-18
28-MAR-18
29-MAR-18
30-MAR-18
31-MAR-18
01-APR-18
02-APR-18
03-APR-18
04-APR-18
05-APR-18
06-APR-18
07-APR-18
08-APR-18
09-APR-18
10-APR-18
11-APR-18
12-APR-18
13-APR-18
14-APR-18
15-APR-18
16-APR-18
17-APR-18
18-APR-18
19-APR-18
20-APR-18
21-APR-18
22-APR-18
23-APR-18
24-APR-18
25-APR-18
26-APR-18
27-APR-18
28-APR-18
29-APR-18
30-APR-18
01-MAY-18
02-MAY-18
03-MAY-18
04-MAY-18
05-MAY-18
06-MAY-18
07-MAY-18
08-MAY-18
09-MAY-18
10-MAY-18
11-MAY-18
12-MAY-18
13-MAY-18
14-MAY-18
15-MAY-18
16-MAY-18
17-MAY-18
18-MAY-18
19-MAY-18
20-MAY-18
21-MAY-18
22-MAY-18
23-MAY-18
24-MAY-18
25-MAY-18
26-MAY-18
27-MAY-18
28-MAY-18
29-MAY-18
30-MAY-18
31-MAY-18
01-JUN-18
02-JUN-18
03-JUN-18
04-JUN-18
05-JUN-18
06-JUN-18
07-JUN-18
08-JUN-18
09-JUN-18
10-JUN-18
11-JUN-18
12-JUN-18
13-JUN-18
14-JUN-18
15-JUN-18
16-JUN-18
17-JUN-18
18-JUN-18
19-JUN-18
20-JUN-18
21-JUN-18
22-JUN-18
23-JUN-18
24-JUN-18
25-JUN-18
26-JUN-18
27-JUN-18
28-JUN-18
29-JUN-18
30-JUN-18
01-JUL-18
02-JUL-18
03-JUL-18
04-JUL-18
05-JUL-18
06-JUL-18
07-JUL-18
08-JUL-18
09-JUL-18
10-JUL-18
11-JUL-18
12-JUL-18
13-JUL-18
14-JUL-18
15-JUL-18
16-JUL-18
17-JUL-18
18-JUL-18
19-JUL-18
20-JUL-18
21-JUL-18
22-JUL-18
23-JUL-18
24-JUL-18
25-JUL-18
26-JUL-18
27-JUL-18
28-JUL-18
29-JUL-18
30-JUL-18
31-JUL-18
01-AUG-18
02-AUG-18
03-AUG-18
04-AUG-18
05-AUG-18
06-AUG-18
07-AUG-18
08-AUG-18
09-AUG-18
10-AUG-18
11-AUG-18
12-AUG-18
13-AUG-18
14-AUG-18
15-AUG-18
16-AUG-18
17-AUG-18
18-AUG-18
19-AUG-18
20-AUG-18
21-AUG-18
22-AUG-18
23-AUG-18
24-AUG-18
25-AUG-18
26-AUG-18
27-AUG-18
28-AUG-18
29-AUG-18
30-AUG-18
31-AUG-18
01-SEP-18
02-SEP-18
03-SEP-18
04-SEP-18
05-SEP-18
06-SEP-18
07-SEP-18
08-SEP-18
09-SEP-18
10-SEP-18
11-SEP-18
12-SEP-18
13-SEP-18
14-SEP-18
15-SEP-18
16-SEP-18
17-SEP-18
18-SEP-18
19-SEP-18
20-SEP-18
21-SEP-18
22-SEP-18
23-SEP-18
24-SEP-18
25-SEP-18
26-SEP-18
27-SEP-18
28-SEP-18
29-SEP-18
30-SEP-18
01-OCT-18
02-OCT-18
03-OCT-18
04-OCT-18
05-OCT-18
06-OCT-18
07-OCT-18
08-OCT-18
09-OCT-18
10-OCT-18
11-OCT-18
12-OCT-18
13-OCT-18
14-OCT-18
15-OCT-18
16-OCT-18
17-OCT-18
18-OCT-18
19-OCT-18
20-OCT-18
21-OCT-18
22-OCT-18
23-OCT-18
24-OCT-18
25-OCT-18
26-OCT-18
27-OCT-18
28-OCT-18
29-OCT-18
30-OCT-18
31-OCT-18
01-NOV-18
02-NOV-18
03-NOV-18
04-NOV-18
05-NOV-18
06-NOV-18
07-NOV-18
08-NOV-18
09-NOV-18
10-NOV-18
11-NOV-18
12-NOV-18
13-NOV-18
14-NOV-18
15-NOV-18
16-NOV-18
17-NOV-18
18-NOV-18
19-NOV-18
20-NOV-18
21-NOV-18
22-NOV-18
23-NOV-18
24-NOV-18
25-NOV-18
26-NOV-18
27-NOV-18
28-NOV-18
29-NOV-18
30-NOV-18
01-DEC-18
02-DEC-18
03-DEC-18
04-DEC-18
05-DEC-18
06-DEC-18
07-DEC-18
08-DEC-18
09-DEC-18
10-DEC-18
11-DEC-18
12-DEC-18
13-DEC-18
14-DEC-18
15-DEC-18
16-DEC-18
17-DEC-18
18-DEC-18
19-DEC-18
20-DEC-18
21-DEC-18
22-DEC-18
23-DEC-18
24-DEC-18
25-DEC-18
26-DEC-18
27-DEC-18
28-DEC-18
29-DEC-18
30-DEC-18
31-DEC-18
01-JAN-19
02-JAN-19
03-JAN-19
04-JAN-19
05-JAN-19
06-JAN-19
07-JAN-19
08-JAN-19
09-JAN-19
10-JAN-19
11-JAN-19
12-JAN-19
13-JAN-19
14-JAN-19
15-JAN-19
16-JAN-19
17-JAN-19
18-JAN-19
19-JAN-19
20-JAN-19
21-JAN-19
22-JAN-19
23-JAN-19
24-JAN-19
25-JAN-19
26-JAN-19
27-JAN-19
28-JAN-19
29-JAN-19
30-JAN-19
31-JAN-19
01-FEB-19
02-FEB-19
03-FEB-19
04-FEB-19
05-FEB-19
06-FEB-19
07-FEB-19
08-FEB-19
09-FEB-19
10-FEB-19
11-FEB-19
12-FEB-19
13-FEB-19
14-FEB-19
15-FEB-19
16-FEB-19
17-FEB-19
18-FEB-19
19-FEB-19
20-FEB-19
21-FEB-19
22-FEB-19
23-FEB-19
24-FEB-19
25-FEB-19
26-FEB-19
27-FEB-19
28-FEB-19
01-MAR-19
02-MAR-19
03-MAR-19
04-MAR-19
05-MAR-19
06-MAR-19
07-MAR-19
08-MAR-19
09-MAR-19
10-MAR-19
11-MAR-19
12-MAR-19
13-MAR-19
14-MAR-19
15-MAR-19
16-MAR-19
17-MAR-19
18-MAR-19
19-MAR-19
20-MAR-19
21-MAR-19
22-MAR-19
23-MAR-19
24-MAR-19
25-MAR-19
26-MAR-19
27-MAR-19
28-MAR-19
29-MAR-19
30-MAR-19
31-MAR-19
01-APR-19
02-APR-19
03-APR-19
04-APR-19
05-APR-19
06-APR-19
07-APR-19
08-APR-19
09-APR-19
10-APR-19
11-APR-19
12-APR-19
13-APR-19
14-APR-19
15-APR-19
16-APR-19
17-APR-19
18-APR-19
19-APR-19
20-APR-19
21-APR-19
22-APR-19
23-APR-19
24-APR-19
25-APR-19
26-APR-19
27-APR-19
28-APR-19
29-APR-19
30-APR-19
01-MAY-19
02-MAY-19
03-MAY-19
04-MAY-19
05-MAY-19
06-MAY-19
07-MAY-19
08-MAY-19
09-MAY-19
10-MAY-19
11-MAY-19
12-MAY-19
13-MAY-19
14-MAY-19
15-MAY-19
16-MAY-19
17-MAY-19
18-MAY-19
19-MAY-19
20-MAY-19
21-MAY-19
22-MAY-19
23-MAY-19
24-MAY-19
25-MAY-19
26-MAY-19
27-MAY-19
28-MAY-19
29-MAY-19
30-MAY-19
31-MAY-19
01-JUN-19
02-JUN-19
03-JUN-19
04-JUN-19
05-JUN-19
06-JUN-19
07-JUN-19
08-JUN-19
09-JUN-19
10-JUN-19
11-JUN-19
12-JUN-19
13-JUN-19
14-JUN-19
15-JUN-19
16-JUN-19
17-JUN-19
18-JUN-19
19-JUN-19
20-JUN-19
21-JUN-19
22-JUN-19
23-JUN-19
24-JUN-19
25-JUN-19
26-JUN-19
27-JUN-19
28-JUN-19
29-JUN-19
30-JUN-19
01-JUL-19
02-JUL-19
03-JUL-19
04-JUL-19
05-JUL-19
06-JUL-19
07-JUL-19
08-JUL-19
09-JUL-19
10-JUL-19
11-JUL-19
12-JUL-19
13-JUL-19
14-JUL-19
15-JUL-19
16-JUL-19
17-JUL-19
18-JUL-19
19-JUL-19
20-JUL-19
21-JUL-19
22-JUL-19
23-JUL-19
24-JUL-19
25-JUL-19
26-JUL-19
27-JUL-19
28-JUL-19
29-JUL-19
30-JUL-19
31-JUL-19
01-AUG-19
02-AUG-19
03-AUG-19
04-AUG-19
05-AUG-19
06-AUG-19
07-AUG-19
08-AUG-19
09-AUG-19
10-AUG-19
11-AUG-19
12-AUG-19
13-AUG-19
14-AUG-19
15-AUG-19
16-AUG-19
17-AUG-19
18-AUG-19
19-AUG-19
20-AUG-19
21-AUG-19
22-AUG-19
23-AUG-19
24-AUG-19
25-AUG-19
26-AUG-19
27-AUG-19
28-AUG-19
29-AUG-19
30-AUG-19
31-AUG-19
01-SEP-19
02-SEP-19
03-SEP-19
04-SEP-19
05-SEP-19
06-SEP-19
07-SEP-19
08-SEP-19
09-SEP-19
10-SEP-19
11-SEP-19
12-SEP-19
13-SEP-19
14-SEP-19
15-SEP-19
16-SEP-19
17-SEP-19
18-SEP-19
19-SEP-19
20-SEP-19
21-SEP-19
22-SEP-19
23-SEP-19
24-SEP-19
25-SEP-19
26-SEP-19
27-SEP-19
28-SEP-19
29-SEP-19
30-SEP-19
01-OCT-19
02-OCT-19
03-OCT-19
04-OCT-19
05-OCT-19
06-OCT-19
07-OCT-19
08-OCT-19
09-OCT-19
10-OCT-19
11-OCT-19
12-OCT-19
13-OCT-19
14-OCT-19
15-OCT-19
16-OCT-19
17-OCT-19
18-OCT-19
19-OCT-19
20-OCT-19
21-OCT-19
22-OCT-19
23-OCT-19
24-OCT-19
25-OCT-19
26-OCT-19
27-OCT-19
28-OCT-19
29-OCT-19
30-OCT-19
31-OCT-19
01-NOV-19
02-NOV-19
03-NOV-19
04-NOV-19
05-NOV-19
06-NOV-19
07-NOV-19
08-NOV-19
09-NOV-19
10-NOV-19
11-NOV-19
12-NOV-19
13-NOV-19
14-NOV-19
15-NOV-19
16-NOV-19
17-NOV-19
18-NOV-19
19-NOV-19
20-NOV-19
21-NOV-19
22-NOV-19
23-NOV-19
24-NOV-19
25-NOV-19
26-NOV-19
27-NOV-19
28-NOV-19
29-NOV-19
30-NOV-19
01-DEC-19
02-DEC-19
03-DEC-19
04-DEC-19
05-DEC-19
06-DEC-19
07-DEC-19
08-DEC-19
09-DEC-19
10-DEC-19
11-DEC-19
12-DEC-19
13-DEC-19
14-DEC-19
15-DEC-19
16-DEC-19
17-DEC-19
18-DEC-19
19-DEC-19
20-DEC-19
21-DEC-19
22-DEC-19
23-DEC-19
24-DEC-19
25-DEC-19
26-DEC-19
27-DEC-19
28-DEC-19
29-DEC-19
30-DEC-19
31-DEC-19

1826 rows selected.

CAL_DATE
01-JAN-15
02-JAN-15
03-JAN-15
04-JAN-15
05-JAN-15
06-JAN-15
07-JAN-15
08-JAN-15
09-JAN-15
10-JAN-15
11-JAN-15
12-JAN-15
13-JAN-15
14-JAN-15
15-JAN-15
16-JAN-15
17-JAN-15
18-JAN-15
19-JAN-15
20-JAN-15
21-JAN-15
22-JAN-15
23-JAN-15
24-JAN-15
25-JAN-15
26-JAN-15
27-JAN-15
28-JAN-15
29-JAN-15
30-JAN-15
31-JAN-15
01-FEB-15
02-FEB-15
03-FEB-15
04-FEB-15
05-FEB-15
06-FEB-15
07-FEB-15
08-FEB-15
09-FEB-15
10-FEB-15
11-FEB-15
12-FEB-15
13-FEB-15
14-FEB-15
15-FEB-15
16-FEB-15
17-FEB-15
18-FEB-15
19-FEB-15
20-FEB-15
21-FEB-15
22-FEB-15
23-FEB-15
24-FEB-15
25-FEB-15
26-FEB-15
27-FEB-15
28-FEB-15
01-MAR-15
02-MAR-15
03-MAR-15
04-MAR-15
05-MAR-15
06-MAR-15
07-MAR-15
08-MAR-15
09-MAR-15
10-MAR-15
11-MAR-15
12-MAR-15
13-MAR-15
14-MAR-15
15-MAR-15
16-MAR-15
17-MAR-15
18-MAR-15
19-MAR-15
20-MAR-15
21-MAR-15
22-MAR-15
23-MAR-15
24-MAR-15
25-MAR-15
26-MAR-15
27-MAR-15
28-MAR-15
29-MAR-15
30-MAR-15
31-MAR-15
01-APR-15
02-APR-15
03-APR-15
04-APR-15
05-APR-15
06-APR-15
07-APR-15
08-APR-15
09-APR-15
10-APR-15
11-APR-15
12-APR-15
13-APR-15
14-APR-15
15-APR-15
16-APR-15
17-APR-15
18-APR-15
19-APR-15
20-APR-15
21-APR-15
22-APR-15
23-APR-15
24-APR-15
25-APR-15
26-APR-15
27-APR-15
28-APR-15
29-APR-15
30-APR-15
01-MAY-15
02-MAY-15
03-MAY-15
04-MAY-15
05-MAY-15
06-MAY-15
07-MAY-15
08-MAY-15
09-MAY-15
10-MAY-15
11-MAY-15
12-MAY-15
13-MAY-15
14-MAY-15
15-MAY-15
16-MAY-15
17-MAY-15
18-MAY-15
19-MAY-15
20-MAY-15
21-MAY-15
22-MAY-15
23-MAY-15
24-MAY-15
25-MAY-15
26-MAY-15
27-MAY-15
28-MAY-15
29-MAY-15
30-MAY-15
31-MAY-15
01-JUN-15
02-JUN-15
03-JUN-15
04-JUN-15
05-JUN-15
06-JUN-15
07-JUN-15
08-JUN-15
09-JUN-15
10-JUN-15
11-JUN-15
12-JUN-15
13-JUN-15
14-JUN-15
15-JUN-15
16-JUN-15
17-JUN-15
18-JUN-15
19-JUN-15
20-JUN-15
21-JUN-15
22-JUN-15
23-JUN-15
24-JUN-15
25-JUN-15
26-JUN-15
27-JUN-15
28-JUN-15
29-JUN-15
30-JUN-15
01-JUL-15
02-JUL-15
03-JUL-15
04-JUL-15
05-JUL-15
06-JUL-15
07-JUL-15
08-JUL-15
09-JUL-15
10-JUL-15
11-JUL-15
12-JUL-15
13-JUL-15
14-JUL-15
15-JUL-15
16-JUL-15
17-JUL-15
18-JUL-15
19-JUL-15
20-JUL-15
21-JUL-15
22-JUL-15
23-JUL-15
24-JUL-15
25-JUL-15
26-JUL-15
27-JUL-15
28-JUL-15
29-JUL-15
30-JUL-15
31-JUL-15
01-AUG-15
02-AUG-15
03-AUG-15
04-AUG-15
05-AUG-15
06-AUG-15
07-AUG-15
08-AUG-15
09-AUG-15
10-AUG-15
11-AUG-15
12-AUG-15
13-AUG-15
14-AUG-15
15-AUG-15
16-AUG-15
17-AUG-15
18-AUG-15
19-AUG-15
20-AUG-15
21-AUG-15
22-AUG-15
23-AUG-15
24-AUG-15
25-AUG-15
26-AUG-15
27-AUG-15
28-AUG-15
29-AUG-15
30-AUG-15
31-AUG-15
01-SEP-15
02-SEP-15
03-SEP-15
04-SEP-15
05-SEP-15
06-SEP-15
07-SEP-15
08-SEP-15
09-SEP-15
10-SEP-15
11-SEP-15
12-SEP-15
13-SEP-15
14-SEP-15
15-SEP-15
16-SEP-15
17-SEP-15
18-SEP-15
19-SEP-15
20-SEP-15
21-SEP-15
22-SEP-15
23-SEP-15
24-SEP-15
25-SEP-15
26-SEP-15
27-SEP-15
28-SEP-15
29-SEP-15
30-SEP-15
01-OCT-15
02-OCT-15
03-OCT-15
04-OCT-15
05-OCT-15
06-OCT-15
07-OCT-15
08-OCT-15
09-OCT-15
10-OCT-15
11-OCT-15
12-OCT-15
13-OCT-15
14-OCT-15
15-OCT-15
16-OCT-15
17-OCT-15
18-OCT-15
19-OCT-15
20-OCT-15
21-OCT-15
22-OCT-15
23-OCT-15
24-OCT-15
25-OCT-15
26-OCT-15
27-OCT-15
28-OCT-15
29-OCT-15
30-OCT-15
31-OCT-15
01-NOV-15
02-NOV-15
03-NOV-15
04-NOV-15
05-NOV-15
06-NOV-15
07-NOV-15
08-NOV-15
09-NOV-15
10-NOV-15
11-NOV-15
12-NOV-15
13-NOV-15
14-NOV-15
15-NOV-15
16-NOV-15
17-NOV-15
18-NOV-15
19-NOV-15
20-NOV-15
21-NOV-15
22-NOV-15
23-NOV-15
24-NOV-15
25-NOV-15
26-NOV-15
27-NOV-15
28-NOV-15
29-NOV-15
30-NOV-15
01-DEC-15
02-DEC-15
03-DEC-15
04-DEC-15
05-DEC-15
06-DEC-15
07-DEC-15
08-DEC-15
09-DEC-15
10-DEC-15
11-DEC-15
12-DEC-15
13-DEC-15
14-DEC-15
15-DEC-15
16-DEC-15
17-DEC-15
18-DEC-15
19-DEC-15
20-DEC-15
21-DEC-15
22-DEC-15
23-DEC-15
24-DEC-15
25-DEC-15
26-DEC-15
27-DEC-15
28-DEC-15
29-DEC-15
30-DEC-15
31-DEC-15
01-JAN-16
02-JAN-16
03-JAN-16
04-JAN-16
05-JAN-16
06-JAN-16
07-JAN-16
08-JAN-16
09-JAN-16
10-JAN-16
11-JAN-16
12-JAN-16
13-JAN-16
14-JAN-16
15-JAN-16
16-JAN-16
17-JAN-16
18-JAN-16
19-JAN-16
20-JAN-16
21-JAN-16
22-JAN-16
23-JAN-16
24-JAN-16
25-JAN-16
26-JAN-16
27-JAN-16
28-JAN-16
29-JAN-16
30-JAN-16
31-JAN-16
01-FEB-16
02-FEB-16
03-FEB-16
04-FEB-16
05-FEB-16
06-FEB-16
07-FEB-16
08-FEB-16
09-FEB-16
10-FEB-16
11-FEB-16
12-FEB-16
13-FEB-16
14-FEB-16
15-FEB-16
16-FEB-16
17-FEB-16
18-FEB-16
19-FEB-16
20-FEB-16
21-FEB-16
22-FEB-16
23-FEB-16
24-FEB-16
25-FEB-16
26-FEB-16
27-FEB-16
28-FEB-16
29-FEB-16
01-MAR-16
02-MAR-16
03-MAR-16
04-MAR-16
05-MAR-16
06-MAR-16
07-MAR-16
08-MAR-16
09-MAR-16
10-MAR-16
11-MAR-16
12-MAR-16
13-MAR-16
14-MAR-16
15-MAR-16
16-MAR-16
17-MAR-16
18-MAR-16
19-MAR-16
20-MAR-16
21-MAR-16
22-MAR-16
23-MAR-16
24-MAR-16
25-MAR-16
26-MAR-16
27-MAR-16
28-MAR-16
29-MAR-16
30-MAR-16
31-MAR-16
01-APR-16
02-APR-16
03-APR-16
04-APR-16
05-APR-16
06-APR-16
07-APR-16
08-APR-16
09-APR-16
10-APR-16
11-APR-16
12-APR-16
13-APR-16
14-APR-16
15-APR-16
16-APR-16
17-APR-16
18-APR-16
19-APR-16
20-APR-16
21-APR-16
22-APR-16
23-APR-16
24-APR-16
25-APR-16
26-APR-16
27-APR-16
28-APR-16
29-APR-16
30-APR-16
01-MAY-16
02-MAY-16
03-MAY-16
04-MAY-16
05-MAY-16
06-MAY-16
07-MAY-16
08-MAY-16
09-MAY-16
10-MAY-16
11-MAY-16
12-MAY-16
13-MAY-16
14-MAY-16

Statement 10

drop table test_values

Table dropped.

Statement 11

create table test_values ( 
    code varchar2(10) not null, 
    date_value date not null, 
    test_value number 
)

Table created.

Statement 12

drop table test_calendar

Table dropped.

Statement 13

create table test_calendar ( 
    cal_date date not null constraint test_calendar_pk primary key 
)

Table created.

Statement 14

DECLARE 
  w_dat date; 
BEGIN 
  w_dat:=to_date('01012015','ddmmyyyy'); 
  loop 
    insert into test_calendar (cal_date) values (trunc(w_dat)); 
    w_dat:=w_dat+1; 
    if w_dat>to_date('31122019','ddmmyyyy') then 
      exit; 
    end if; 
  end loop; 
  commit; 
END;

1 row(s) inserted.

Statement 15

insert into test_values (code,date_value,test_value) values ('Code1',to_date('15032017','ddmmyyyy'),25000)

1 row(s) inserted.

Statement 16

insert into test_values (code,date_value,test_value) values ('Code1',to_date('06062017','ddmmyyyy'),26000)

1 row(s) inserted.

Statement 17

insert into test_values (code,date_value,test_value) values ('Code1',to_date('18072017','ddmmyyyy'),29000)

1 row(s) inserted.

Statement 18

insert into test_values (code,date_value,test_value) values ('Code1',to_date('21072017','ddmmyyyy'),3000)

1 row(s) inserted.

Statement 19

insert into test_values (code,date_value,test_value) values ('Code1',to_date('05102017','ddmmyyyy'),35000)

1 row(s) inserted.

Statement 20

insert into test_values (code,date_value,test_value) values ('Code2',to_date('18072017','ddmmyyyy'),89000)

1 row(s) inserted.

Statement 21

drop table test_values

Table dropped.

Statement 22

create table test_values ( 
    code varchar2(10) not null, 
    date_value date not null, 
    test_value number 
)

Table created.

Statement 23

drop table test_calendar

Table dropped.

Statement 24

create table test_calendar ( 
    cal_date date not null constraint test_calendar_pk primary key 
)

Table created.

Statement 25

DECLARE 
  w_dat date; 
BEGIN 
  w_dat:=to_date('01012015','ddmmyyyy'); 
  loop 
    insert into test_calendar (cal_date) values (trunc(w_dat)); 
    w_dat:=w_dat+1; 
    if w_dat>to_date('31122019','ddmmyyyy') then 
      exit; 
    end if; 
  end loop; 
  commit; 
END;

1 row(s) inserted.

Statement 26

insert into test_values (code,date_value,test_value) values ('Code1',to_date('15032017','ddmmyyyy'),25000)

1 row(s) inserted.

Statement 27

insert into test_values (code,date_value,test_value) values ('Code1',to_date('06062017','ddmmyyyy'),26000)

1 row(s) inserted.

Statement 28

insert into test_values (code,date_value,test_value) values ('Code1',to_date('18072017','ddmmyyyy'),29000)

1 row(s) inserted.

Statement 29

insert into test_values (code,date_value,test_value) values ('Code1',to_date('21072017','ddmmyyyy'),3000)

1 row(s) inserted.

Statement 30

insert into test_values (code,date_value,test_value) values ('Code1',to_date('05102017','ddmmyyyy'),35000)

1 row(s) inserted.

Statement 31

insert into test_values (code,date_value,test_value) values ('Code2',to_date('18072017','ddmmyyyy'),89000)

1 row(s) inserted.

Statement 32

commit

Statement processed.

Statement 33

drop table test_values

Table dropped.

Statement 34

create table test_values ( 
    code varchar2(10) not null, 
    date_value date not null, 
    test_value number 
)

Table created.

Statement 35

drop table test_calendar

Table dropped.

Statement 36

create table test_calendar ( 
    cal_date date not null constraint test_calendar_pk primary key 
)

Table created.

Statement 37

DECLARE 
  w_dat date; 
BEGIN 
  w_dat:=to_date('01012015','ddmmyyyy'); 
  loop 
    insert into test_calendar (cal_date) values (trunc(w_dat)); 
    w_dat:=w_dat+1; 
    if w_dat>to_date('31122019','ddmmyyyy') then 
      exit; 
    end if; 
  end loop; 
  commit; 
END;

1 row(s) inserted.

Statement 38

insert into test_values (code,date_value,test_value) values ('Code1',to_date('15032017','ddmmyyyy'),25000)

1 row(s) inserted.

Statement 39

insert into test_values (code,date_value,test_value) values ('Code1',to_date('06062017','ddmmyyyy'),26000)

1 row(s) inserted.

Statement 40

insert into test_values (code,date_value,test_value) values ('Code1',to_date('18072017','ddmmyyyy'),29000)

1 row(s) inserted.

Statement 41

insert into test_values (code,date_value,test_value) values ('Code1',to_date('21072017','ddmmyyyy'),3000)

1 row(s) inserted.

Statement 42

insert into test_values (code,date_value,test_value) values ('Code1',to_date('05102017','ddmmyyyy'),35000)

1 row(s) inserted.

Statement 43

insert into test_values (code,date_value,test_value) values ('Code2',to_date('18072017','ddmmyyyy'),89000)

1 row(s) inserted.

Statement 44

commit

Statement processed.

Select_analytics_graph

Additional Information