2 Replies Latest reply: Jan 27, 2014 7:53 AM by 023fa390-4e3f-4b7e-aef4-b0cb7f421a19 RSS

    Pivot Dynamic for Query in Oracle SQL DEVELOPER ??

    023fa390-4e3f-4b7e-aef4-b0cb7f421a19

      Hi

      I have the following question, someone who has a dynamic pivot.

      I need a dynamic query that is that when the transfer column to row do receiving any type declared as these can change data.

      Example:

       

      ID_PROJECTPROJECT STAGESDATE
      12345Requirement Analysis17-01-2013
      12345Quotation20-01-2013
      12345Project Preparation29-01-2013
      12345Model Verification04-02-2013
      12345Closed requirement10-02-2013
      23456Building and Unit Tests

       

      With dynamic pivot:

       

      ID_PROJECT
      Requirement Analysis
      QuotationProject PreparationModel VerificationClosed requirement
      1234517-01-201320-01-201329-01-201304-02-201310-02-2013

      I mean that in this case the stages of the project will be changing.