pivot

Discussion List

• 
  Pivot table result without aggregate function (string data type)

  Solution Accepted User_SAPZL 145 views 12 comments 0 points Most recent by Solomon Yakobson Sep 10, 2022 1:41PMSQL & PL/SQL
• 
  Multiple column pivot

  Solution Accepted New Roots 62 views 6 comments 1 point Most recent by New Roots Aug 25, 2022 2:43AMSQL & PL/SQL
• 
  IDENTIFY UNIQUE ROW IN TABLE WHILE USING PIVOT AND GROUP BY

  Responded But No Solution User_N31VH 22 views 2 comments 0 points Most recent by Stax Aug 2, 2022 5:50AMSQL & PL/SQL
• 
  dynamic pivot: generate static columns from uknown records

  Solution Accepted User_2SRRN 25 views 4 comments 0 points Most recent by User_2SRRN Jun 9, 2022 11:12AMSQL & PL/SQL
• 
  Question on Pivot Table Limitations with Interactive Reports

  Responded But No Solution FriendlyTooo 46 views 1 comment 0 points Most recent by Adnan.Salim Feb 14, 2022 7:28AMAPEX Discussions
• 
  dvt:pivotTable Table dynamically using Row set

  Max Done 31 views 8 comments 0 points Most recent by dvohra21 Feb 3, 2022 9:53PMJDeveloper and ADF
• 
  Sql Query for reporting

  Solution Accepted Jeevan Anand 52 views 4 comments 0 points Most recent by Jeevan Anand Jan 25, 2022 11:14AMSQL & PL/SQL
• 
  dvt:pivotTable refresh entered value after reenter to input.

  Solution Accepted Perevertkin M A 17 views 4 comments 0 points Most recent by Perevertkin M A Nov 21, 2021 7:14PMJDeveloper and ADF
• 
  pivoting data

  Solution Accepted Devx 31 views 3 comments 0 points Most recent by Frank Kulash Nov 4, 2021 8:52PMSQL & PL/SQL
• 
  Conditional cell color on a pivot report (Interactive Report)

  Question Riassuncao 166 views 0 comments 0 points Started by Riassuncao Jul 8, 2021 5:34PM APEX Discussions
• 
  Oracle Pivot

  Solution Accepted user9311128 31 views 2 comments 0 points Most recent by user9311128 May 27, 2021 12:01PMSQL & PL/SQL
• 
  PIVOT and UNPIVOT

  Solution Accepted HayXing 42 views 7 comments 0 points Most recent by Frank Kulash Apr 20, 2021 12:18AMSQL & PL/SQL
• 
  display old and new values for n values of a column in a table

  Solution Accepted Uday_N 88 views 8 comments 0 points Most recent by OTDeveloper Feb 15, 2021 11:23PMSQL & PL/SQL
• 
  How to download Pivoted Data in xlsx format from Interactive report

  Responded But No Solution Rakesh119 21 views 2 comments 0 points Most recent by Veda Sooguru Jan 20, 2021 2:59AMAPEX Discussions
• 
  <dvt:pivotTable> Highlight columns with background color

  Responded But No Solution user1163882 83 views 5 comments 0 points Most recent by Timo Hahn Dec 22, 2020 11:17PMJDeveloper and ADF
• 
  Transposing Rows into Columns (Except the number of columns could vary)

  Solution Accepted Roxy rollers 31 views 5 comments 0 points Most recent by Frank Kulash Nov 24, 2020 7:15PMSQL & PL/SQL
• 
  pivot report with dynamic names

  Responded But No Solution Balaji_Madhavan 11 views 1 comment 0 points Most recent by Frank Kulash Nov 24, 2020 11:48AMSQL & PL/SQL
• 
  Pivot report in IR without Function

  Question Balaji_Madhavan 11 views 0 comments 0 points Started by Balaji_Madhavan Nov 22, 2020 12:13PM APEX Discussions
• 
  How to dynamically transpose data into with changing column headers with or without pivot/pivot xml?

  Responded But No Solution Vinipanda 1.1K views 3 comments 0 points Most recent by Frank Kulash Nov 18, 2020 12:18AMSQL & PL/SQL
• 
  Convert rows to columns where all data is TEXT (no aggregation)

  Responded But No Solution pepperbr 75 views 4 comments 0 points Most recent by Ivan84F Oct 16, 2020 1:31PMSQL & PL/SQL
• 
  Update pivot columns of an Interactive Grid?

  Question britoo95 174 views 0 comments 0 points Started by britoo95 Jun 27, 2020 11:16AM APEX Discussions
• 
  Rollup in pivot query

  Responded But No Solution Tod Goulds-Oracle 179 views 2 comments 0 points Most recent by mathguy May 21, 2020 10:25AMSQL & PL/SQL
• 
  finding the min date of different dataset and pivoting

  Responded But No Solution Devx 115 views 8 comments 0 points Most recent by mathguy Mar 7, 2020 10:01PMSQL & PL/SQL