sql

Discussion List

• 
  How the SQl statement execute internally

  Responded But No Solution Kumarnkl 22 views 1 comment 0 points Most recent by Frank Kulash Jul 2, 2022 1:12PMSQL & PL/SQL
• 
  Get highest average grade for each course

  Solution Accepted User_G3NSO 15 views 5 comments 0 points Most recent by User_G3NSO Jul 1, 2022 7:58PMSQL & PL/SQL
• 
  Need SQL query without CASE statement

  Responded But No Solution User_X9S6M 33 views 2 comments 0 points Most recent by Frank Kulash Jul 1, 2022 9:32AMSQL & PL/SQL
• 
  Grouping After Sorting

  Solution Accepted sect55 25 views 3 comments 0 points Most recent by sect55 Jun 30, 2022 4:05PMSQL & PL/SQL
• 
  Select statements inside a select query

  Responded But No Solution Bikram 30 views 1 comment 0 points Most recent by Frank Kulash Jun 29, 2022 5:06PMSQL & PL/SQL
• 
  show all locations that do not meet certain requirements

  Solution Accepted Bjornlaat 19 views 2 comments 0 points Most recent by Bjornlaat Jun 29, 2022 11:46AMSQL & PL/SQL
• 
  Creating range of dates for user using a function

  Solution Accepted BeefStu 33 views 3 comments 0 points Most recent by Solomon Yakobson Jun 28, 2022 11:08PMSQL & PL/SQL
• 
  How to get unique random numbers?

  Responded But No Solution foxhound 47 views 3 comments 0 points Most recent by User_3ABCE Jun 28, 2022 8:33PMSQL & PL/SQL
• 
  MOD function with embedded LOG function gives an incorrect result

  Responded But No Solution User_8MZ3Y 18 views 4 comments 0 points Most recent by Solomon Yakobson Jun 28, 2022 4:59PMGeneral Database Discussions
• 
  Trigger creation comparison then insert records

  Responded But No Solution User_IAP38 13 views 3 comments 0 points Most recent by Frank Kulash Jun 28, 2022 4:59PMSQL & PL/SQL
• 
  Oracle APEX cumulative sum / running total over month and year

  Responded But No Solution hiddenonearth 28 views 2 comments 0 points Most recent by Stax Jun 28, 2022 12:44PMAPEX Discussions
• 
  ORA-00997: illegal use of LONG datatype

  Responded But No Solution Santhosh T 8 views 2 comments 0 points Most recent by Santhosh T Jun 28, 2022 8:58AMGeneral Database Discussions
• 
  Get XML elements from XML with namespace, without pointing the namespace

  Solution Accepted Dominik Jasek 81 views 5 comments 0 points Most recent by Dominik Jasek Jun 27, 2022 5:54AMSQL & PL/SQL
• 
  Hierarchical - Previous value and same value filling

  Solution Accepted Rengudi 27 views 3 comments 0 points Most recent by Rengudi Jun 27, 2022 5:51AMSQL & PL/SQL
• 
  Procedure Mutirecords or Single Record

  Responded But No Solution user1849 32 views 3 comments 0 points Most recent by Frank Kulash Jun 26, 2022 5:09PMSQL & PL/SQL
• 
  Need help with analytic function

  Solution Accepted User_K6LH0 141 views 12 comments 0 points Most recent by User_K6LH0 Jun 25, 2022 2:06PMSQL & PL/SQL
• 
  Inserting duplicate entries into the target table using MERGE

  Solution Accepted Albert Chao 51 views 6 comments 0 points Most recent by Albert Chao Jun 23, 2022 1:36PMSQL & PL/SQL
• 
  Convert number to time

  Solution Accepted Bjornlaat 61 views 13 comments 0 points Most recent by BluShadow Jun 23, 2022 11:22AMSQL & PL/SQL
• 
  RETURN row with highest averages attendance

  Responded But No Solution User_G3NSO 21 views 2 comments 0 points Most recent by mathguy Jun 23, 2022 12:49AMSQL & PL/SQL
• 
  Creating data with dbms_random

  Solution Accepted BeefStu 62 views 13 comments 0 points Most recent by Stax Jun 22, 2022 10:18AMSQL & PL/SQL
• 
  Converting text/html to application/json

  Responded But No Solution User_1BMXN 19 views 1 comment 0 points Most recent by User_1BMXN Jun 22, 2022 9:11AMSQL Developer
• 
  Need help with writing a query!

  Solution Accepted User_K6LH0 208 views 16 comments 0 points Most recent by User_K6LH0 Jun 22, 2022 3:56AMSQL & PL/SQL
• 
  Check tables with specific columns

  Solution Accepted user545194 61 views 10 comments 0 points Most recent by user545194 Jun 20, 2022 3:36PMSQL & PL/SQL
• 
  How to get the count of records by status by Month historically for reporting. Ex: Count of active

  Solution Accepted Anuswadh 61 views 11 comments 0 points Most recent by Solomon Yakobson Jun 17, 2022 3:41PMSQL & PL/SQL
• 
  delete duplicate rows without pseudo columns like rowid

  Responded But No Solution ora_1978 173 views 19 comments 0 points Most recent by Stax Jun 16, 2022 12:14PMSQL & PL/SQL