SQL & PL/SQL

Pivot help - Strings not values

Mr NeilMay 24 2016 — edited May 24 2016

Hey all,

I need some direction on how to achieve the following outcome.

I've used 11g pivot before with values that suited the (mandatory) aggrigate function, but I can't see a solution for this. Any help appreciated.

WORKER	05/23/2016	05/24/2016	05/25/2016	05/26/2016
John	Project_A
John	Project_B
Steve		Project_A
Steve		Project_B
Mary	Project_A	Project_A	Project_A	Project_A

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 21 2016

Added on May 24 2016

3 comments

153 views