pivot

Discussion List

• 
  Conditional cell color on a pivot report (Interactive Report)

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

  Solution Accepted user9311128 32 views 2 comments 0 points Most recent by user9311128 May 27, 2021 12:01PMSQL & PL/SQL
• 
  Question on Pivot Table Limitations with Interactive Reports

  Question FriendlyTooo 18 views 0 comments 0 points Started by FriendlyTooo Apr 29, 2021 2:14PM APEX Discussions
• 
  PIVOT and UNPIVOT

  Solution Accepted HayXing 44 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 33 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 22 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 47 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 34 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 13 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 13 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 159 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 31 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 73 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 88 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
• 
  SQL help me (Pivot ?)

  Responded But No Solution gastonlopez500-JavaNet 86 views 5 comments 2 points Most recent by gastonlopez500-JavaNet Mar 3, 2020 12:30PMSQL & PL/SQL
• 
  Subscribe to pivot report

  Question Waggers 27 views 0 comments 0 points Started by Waggers Nov 26, 2019 7:23AM APEX Discussions
• 
  Dynamic Sql pivot procedure - HELP!

  Solution Accepted RichDW 264 views 12 comments 0 points Most recent by RichDW Oct 18, 2019 10:46AMAPEX Discussions
• 
  Get Difference Between Timestamps Using Pivot

  Solution Accepted User_OMEF8 283 views 19 comments 2 points Most recent by User_OMEF8 Sep 5, 2019 3:18PMSQL & PL/SQL
• 
  To display multiple row data in one row

  Responded But No Solution User910243567 133 views 3 comments 1 point Most recent by Frank Kulash Jun 11, 2019 10:26AMSQL & PL/SQL
• 
  Dynamic pivot query?

  Responded But No Solution ab_roman 509 views 3 comments 1 point Most recent by BluShadow Apr 29, 2019 3:17AMSQL & PL/SQL
• 
  PIVOT vs GROUP BY

  Solution Accepted user13117585 275 views 14 comments 0 points Most recent by user13117585 Apr 6, 2019 11:57AMSQL & PL/SQL
• 
  Oracle PIVOT with nvl,ltrim,rtrim where clause doesnt work with NLS_SORT=BINARY_CI

  Responded But No Solution TP0692 503 views 18 comments 3 points Most recent by Solomon Yakobson Mar 13, 2019 7:07AMSQL & PL/SQL
• 
  Pivot/unpivot

  Solution Accepted Dorian Grim 259 views 13 comments 2 points Most recent by Dorian Grim Mar 11, 2019 4:08AMSQL & PL/SQL