Hi All,
I have table like table 1 that has following columns like 'Process' column has 'startprocess' and 'endprocess' two values , in next column 'activity', i have same value in all rows i.e 'Acftivityname' . Last two columns are timestamp datatype has timestamp values .
Process | Activity | Activitystartdate | Activityenddate |
---|
StartProcess | Activityname | 01/APR/2017 10:30:00 AM | 01/APR/2017 11:30:00 AM |
EndProcess | Activityname | 01/APR/2017 02:30:00 PM | 01/APR/2017 03:30:00 PM |
StartProcess | Activityname | 03/APR/2017 08:30:00 PM | 03/APR/2017 09:30:00 PM |
EndProcess | Activityname | 03/APR/2017 10:30:00 PM | 03/APR/2017 11:45:00 PM |
From the above available value , i need to display as below, Highlighted in red are to be displayed in single line as below, How to achieve this Kindly help to solve this Thanks in advance .
Activity | Activitystartdate | activityendtime |
---|
Activityname | 01/APR/2017 10:30:00 AM | 01/APR/2017 03:30:00 PM |
Activityname | 03/APR/2017 08:30:00 PM | 03/APR/2017 11:45:00 PM |
| | |
Regards,
Guru