pivot

Discussion List

• 
  SQL Pivot Question.

  Responded But No Solution Sri G 51 views 4 comments 0 points Most recent by Solomon Yakobson Jan 7, 2023 1:16PMSQL & PL/SQL
• 
  matrix view with year and month

  Solution Accepted af_2017 82 views 10 comments 0 points Most recent by af_2017 Dec 13, 2022 4:21PMSQL & PL/SQL
• 
  How to dynamically pivot on unknown column.

  Solution Accepted User_5F8TP 174 views 9 comments 0 points Most recent by Marwim Dec 1, 2022 12:37PMSQL & PL/SQL
• 
  Pivot table result without aggregate function (string data type)

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

  Solution Accepted New Roots 63 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 21 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 22 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 44 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 32 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 11 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 195 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 197 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 23 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 111 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.4K 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 293 views 4 comments 0 points Most recent by Ivan84F Oct 16, 2020 1:31PMSQL & PL/SQL