sql pl sql

Discussion List

• 
  Compare and get the new data inserted into table based on month

  Solution Accepted Closed user12251389 108 views 2 comments 1 point Most recent by Saubhik Sep 6, 2018 4:42AMSQL & PL/SQL
• 
  LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora'

  Responded But No Solution Closed Christy H. 5.8K views 4 comments 1 point Most recent by clcarter Sep 4, 2018 10:27AMOracle Database Express Edition (XE)
• 
  sql to split total time taken into chunks

  Solution Accepted Closed 3264939 616 views 15 comments 3 points Most recent by Stew Ashton Aug 31, 2018 6:25AMSQL & PL/SQL
• 
  Alternative query

  Responded But No Solution Closed ora_1978 84 views 3 comments 1 point Most recent by Cookiemonster76 Aug 28, 2018 6:02AMSQL & PL/SQL
• 
  DBMS_XPLAN.display_cursor shows wrong elapsed time on nested loops

  Solution Accepted Closed User_HMTR3 211 views 8 comments 2 points Most recent by mathguy Aug 26, 2018 3:40AMSQL & PL/SQL
• 
  ODCITable Implementation doesn't call ODCITablePrepare correctly

  Responded But No Solution Closed 3261255 137 views 5 comments 0 points Most recent by Unknown Aug 24, 2018 11:38AMSQL & PL/SQL
• 
  Passing a parameter value for like contd..

  Solution Accepted Closed palkodi 102 views 4 comments 1 point Most recent by Frank Kulash Aug 23, 2018 11:46AMSQL & PL/SQL
• 
  select the string between the delimter column value

  Solution Accepted Closed New Roots 126 views 9 comments 2 points Most recent by Frank Kulash Aug 22, 2018 9:45AMSQL & PL/SQL
• 
  SQL Query Split hourly transactions into 12 equal interval

  Solution Accepted Closed 3761050 146 views 6 comments 2 points Most recent by jaramill Aug 21, 2018 3:26PMSQL & PL/SQL
• 
  Display only max date rest needs to be null

  Solution Accepted Closed palkodi 84 views 4 comments 1 point Most recent by palkodi Aug 20, 2018 3:23PMSQL & PL/SQL
• 
  Comparing results of 3 different select-statements

  Solution Accepted Closed Zudar 221 views 6 comments 1 point Most recent by Stew Ashton Aug 17, 2018 9:51AMSQL & PL/SQL
• 
  Call another script inside PL/SQL using a variable from a parameter

  Responded But No Solution Closed 3756264 428 views 10 comments 4 points Most recent by Barbara Boehmer Aug 16, 2018 2:20PMSQL & PL/SQL
• 
  Null value in hierarchical query for APEX tree view in APEX 5.1

  Responded But No Solution Closed Madona328-Oracle 73 views 1 comment 0 points Most recent by Hilary Farrell-Oracle Aug 15, 2018 9:45AMAPEX Discussions
• 
  Handling empty values in sql query bound to page items in oracle apex 5.1

  Solution Accepted Closed Madona328-Oracle 182 views 2 comments 0 points Most recent by Madona328-Oracle Aug 14, 2018 4:45AMAPEX Discussions
• 
  Puzzle Scenario : Working out with combinations

  Responded But No Solution Closed User_FRTCM 252 views 7 comments 0 points Most recent by Etbin Aug 11, 2018 5:00AMSQL & PL/SQL
• 
  how to get week numbers along with start and end dates of a week

  Solution Accepted Closed Ramya-Oracle 546 views 13 comments 1 point Most recent by John_K Aug 10, 2018 5:20PMSQL & PL/SQL
• 
  Need help in sql

  Responded But No Solution Closed e9c1784e-76cf-4460-aa2c-3c6d2aac947d 103 views 5 comments 2 points Most recent by RogerT Aug 10, 2018 2:40AMSQL & PL/SQL
• 
  Help SQL

  Responded But No Solution Closed e9c1784e-76cf-4460-aa2c-3c6d2aac947d 65 views 1 comment 0 points Most recent by Frank Kulash Aug 10, 2018 1:10AMSQL & PL/SQL
• 
  XMLTABLE : Convert XML Data into Rows and Columns using SQL

  Solution Accepted Closed Piero Mestici 336 views 7 comments 0 points Most recent by mNem Aug 7, 2018 10:50PMSQL & PL/SQL
• 
  Check if given date is past date of a given month

  Solution Accepted Closed 3751736 830 views 12 comments 3 points Most recent by John Thorton Aug 2, 2018 3:26PMSQL & PL/SQL
• 
  Validating JSON in the database

  Solution Accepted Closed hsemar 558 views 4 comments 1 point Most recent by Roland Mueller Aug 1, 2018 6:48AMSQL & PL/SQL
• 
  oracle query performance issue

  Responded But No Solution Closed ora_1978 202 views 12 comments 0 points Most recent by jaramill Jul 31, 2018 4:13PMSQL & PL/SQL
• 
  How To get Hour so Far for Specific Date in Sql Query

  Solution Accepted Closed user11691341 687 views 8 comments 0 points Most recent by Arun Kumar Gupta Jul 31, 2018 2:43AMSQL & PL/SQL
• 
  sql formation problem

  Solution Accepted Closed 2975394 564 views 34 comments 3 points Most recent by jaramill Jul 27, 2018 9:30AMSQL & PL/SQL
• 
  Issue with creating a backup table

  Solution Accepted Closed RajeshKota 90 views 5 comments 2 points Most recent by EdStevens Jul 27, 2018 9:28AMSQL & PL/SQL