Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help needed to Pivot value

GuruKumarApr 12 2017 — edited Apr 19 2017

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 .

ProcessActivityActivitystartdateActivityenddate
StartProcessActivityname01/APR/2017 10:30:00 AM01/APR/2017 11:30:00 AM
EndProcessActivityname01/APR/2017 02:30:00 PM01/APR/2017 03:30:00 PM
StartProcessActivityname03/APR/2017 08:30:00 PM03/APR/2017 09:30:00 PM
EndProcessActivityname03/APR/2017 10:30:00 PM03/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 .

ActivityActivitystartdateactivityendtime
Activityname01/APR/2017 10:30:00 AM01/APR/2017 03:30:00 PM
Activityname03/APR/2017 08:30:00 PM03/APR/2017 11:45:00 PM

Regards,

Guru
This post has been answered by GuruKumar on Apr 13 2017
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 17 2017
Added on Apr 12 2017
#pivot, #plsql, #sql
7 comments
299 views