1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
select NULL as LINK,'TASK 22' as NAME, 7 as ID, 5 as PARENT_ID, To_Date('2015/10/20', 'YYYY/MM/DD') as ACTUAL_START, To_Date('2015/11/20', 'YYYY/MM/DD') as ACTUAL_END, 0 as PROGRESS from DUAL
union all
select NULL as LINK,'TASK 11' as NAME, 8 as ID, 1 as PARENT_ID, To_Date('2015/09/01', 'YYYY/MM/DD') as ACTUAL_START, To_Date('2015/10/01', 'YYYY/MM/DD') as ACTUAL_END, 0 as PROGRESS from DUAL
union all
select NULL as LINK,'TASK 12' as NAME, 3 as ID, 1 as PARENT_ID, To_Date('2015/09/15', 'YYYY/MM/DD') as ACTUAL_START, To_Date('2015/10/20', 'YYYY/MM/DD') as ACTUAL_END, 0 as PROGRESS from DUAL
union all
select NULL as LINK,'PROJECT 1' as NAME, 1 as ID, NULL as PARENT_ID, To_Date('2015/09/01', 'YYYY/MM/DD') as ACTUAL_START, To_Date('2015/10/25', 'YYYY/MM/DD') as ACTUAL_END, 0 as PROGRESS from DUAL
union all
select NULL as LINK,'TASK 13' as NAME, 6 as ID, 1 as PARENT_ID, To_Date('2015/10/01', 'YYYY/MM/DD') as ACTUAL_START, To_Date('2015/10/25', 'YYYY/MM/DD') as ACTUAL_END, 0 as PROGRESS from DUAL
union all
select NULL as LINK,'PROJECT 2' as NAME, 5 as ID, NULL as PARENT_ID, To_Date('2015/10/01', 'YYYY/MM/DD') as ACTUAL_START, To_Date('2015/12/31', 'YYYY/MM/DD') as ACTUAL_END, 0 as PROGRESS from DUAL
union all
select NULL as LINK,'TASK 21' as NAME, 4 as ID, 5 as PARENT_ID, To_Date('2015/10/01', 'YYYY/MM/DD') as ACTUAL_START, To_Date('2015/11/01', 'YYYY/MM/DD') as ACTUAL_END, 0 as PROGRESS from DUAL
union all
select NULL as LINK,'TASK 23' as NAME, 2 as ID, 5 as PARENT_ID, To_Date('2015/10/25', 'YYYY/MM/DD') as ACTUAL_START, To_Date('2015/12/31', 'YYYY/MM/DD') as ACTUAL_END, 0 as PROGRESS from DUAL
union all
select NULL as LINK,'TASK 31' as NAME, 9 as ID, 11 as PARENT_ID, To_Date('2015/10/01', 'YYYY/MM/DD') as ACTUAL_START, To_Date('2015/10/31', 'YYYY/MM/DD') as ACTUAL_END, 0 as PROGRESS from DUAL
union all
select NULL as LINK,'PROJECT 3' as NAME, 11 as ID, NULL as PARENT_ID, To_Date('2015/09/01', 'YYYY/MM/DD') as ACTUAL_START, To_Date('2015/10/31', 'YYYY/MM/DD') as ACTUAL_END, 0 as PROGRESS from DUAL
union all
select NULL as LINK,'TASK 32' as NAME, 10 as ID, 11 as PARENT_ID, To_Date('2015/09/01', 'YYYY/MM/DD') as ACTUAL_START, To_Date('2015/11/01', 'YYYY/MM/DD') as ACTUAL_END, 0 as PROGRESS from DUAL
union all
select NULL as LINK,'TASK 33' as NAME, 12 as ID, 11 as PARENT_ID, To_Date('2015/09/01', 'YYYY/MM/DD') as ACTUAL_START, To_Date('2015/10/31', 'YYYY/MM/DD') as ACTUAL_END, 0 as PROGRESS from DUAL
