query

Discussion List

• 
  Huge performance drop after upgrading from 12c o 19c

  Question user8740803 12 views 0 comments 0 points Started by user8740803 Oct 12, 2021 8:24PM Database Upgrade
• 
  Long query with WITH not responding

  Responded But No Solution Reversi72 116 views 13 comments 0 points Most recent by JonWat Oct 12, 2021 7:22PMSQL & PL/SQL
• 
  ORA-01843: not a valid month

  Responded But No Solution User_3KSKY 46 views 2 comments 0 points Most recent by Frank Kulash Sep 28, 2021 12:19PMSQL & PL/SQL
• 
  Select XML statement problem

  Solution Accepted Frank Lehmann 43 views 5 comments 0 points Most recent by BluShadow Sep 23, 2021 7:48AMSQL & PL/SQL
• 
  sdo_nn_distance returning 0 19c

  Question User_GK50K 2 views 0 comments 0 points Started by User_GK50K Sep 17, 2021 7:22AM General Database Discussions
• 
  Slow Query

  Responded But No Solution n1248 34 views 3 comments 0 points Most recent by n1248 Sep 7, 2021 3:37PMSQL & PL/SQL
• 
  Recursive CTE pulling values from another table

  Solution Accepted BeefStu 62 views 10 comments 0 points Most recent by BeefStu Aug 20, 2021 11:58AMSQL & PL/SQL
• 
  Pkg without Body

  Solution Accepted User_8NS7E 32 views 5 comments 0 points Most recent by User_H3J7U Aug 18, 2021 8:20AMSQL & PL/SQL
• 
  Update 340 Million of rows.

  Responded But No Solution ApparaoAkki-Oracle 74 views 10 comments 0 points Most recent by Jonathan Lewis Aug 13, 2021 7:19PMSQL & PL/SQL
• 
  Performance issue with set_g_nls_decimal_separator

  Solution Accepted weindla 134 views 13 comments 0 points Most recent by Srini-S Aug 13, 2021 5:37AMAPEX Discussions
• 
  GET MAX analytic function

  Solution Accepted User_SWR12 53 views 4 comments 0 points Most recent by mathguy Aug 12, 2021 3:19PMSQL & PL/SQL
• 
  Create a dynamic Table using procedure

  Responded But No Solution User_KKLFR 53 views 4 comments 0 points Most recent by Frank Kulash Aug 6, 2021 6:18PMSQL & PL/SQL
• 
  How can I conditionally display entries in a column as links only if a query does not come up empty?

  Responded But No Solution Pearl 36 views 7 comments 0 points Most recent by pkpanda Jul 17, 2021 8:48AMAPEX Discussions
• 
  How can I view the outcome of a query rewrite of the optimizer?

  Solution Accepted User_J8SS7 12 views 2 comments 0 points Most recent by User_J8SS7 Jul 16, 2021 3:48PMSQL & PL/SQL
• 
  Bug? Inline functions, multiple queries, and F9

  Solution Accepted user1175386 22 views 1 comment 0 points Most recent by KayK Jul 15, 2021 5:58AMSQL Developer
• 
  First rec of the last group!!!

  Solution Accepted Thirumoorthy Selvaraj 52 views 4 comments 0 points Most recent by mathguy Jul 14, 2021 2:10AMSQL & PL/SQL
• 
  Query finding First Rec out of Latest Group

  Responded But No Solution Closed user6417373 32 views 1 comment 0 points Most recent by Frank Kulash Jul 13, 2021 7:38PMSQL & PL/SQL
• 
  Combining multiple rows to get a single one

  Responded But No Solution User_UJ80K 62 views 4 comments 0 points Most recent by Frank Kulash Jul 12, 2021 12:20PMSQL & PL/SQL
• 
  closing and opening balance SQL

  Solution Accepted AQH 79 views 8 comments 0 points Most recent by AQH Jul 6, 2021 5:27PMSQL & PL/SQL
• 
  closing and opening balance SQL

  Question AQH 22 views 0 comments 0 points Started by AQH Jul 6, 2021 2:15PM APEX Discussions
• 
  Query very slow when querying by a specific value in a specific column

  Solution Accepted Astro313 55 views 10 comments 0 points Most recent by Jonathan Lewis Jun 28, 2021 3:36PMGeneral Database Discussions
• 
  How to conditionally format columns in an interactive grid using data from another column?

  Responded But No Solution Zoie 50 views 1 comment 0 points Most recent by user7911366 Jun 18, 2021 11:03PMAPEX Discussions
• 
  Query help required

  User_4LC0G 32 views 5 comments 0 points Most recent by User_4LC0G Jun 1, 2021 3:19PMSQL & PL/SQL