sql

Discussion List

• 
  Group uninterrupted days for min Balance?

  Solution Accepted User_ZR3PE 28 views 5 comments 0 points Most recent by User_ZR3PE Dec 3, 2022 3:35PMSQL & PL/SQL
• 
  ORA-01843 not a valid month when trying to use Case Statements

  Responded But No Solution User_MXQR1 25 views 2 comments 0 points Most recent by Frank Kulash Dec 2, 2022 10:39PMSQL & PL/SQL
• 
  sql loader passing dynamic values issue

  Responded But No Solution User_IAP38 61 views 4 comments 0 points Most recent by Solomon Yakobson Dec 2, 2022 3:34PMSQL & PL/SQL
• 
  Removing special characters from list

  Responded But No Solution Rengudi 47 views 4 comments 0 points Most recent by BluShadow Dec 2, 2022 10:30AMSQL & PL/SQL
• 
  Merge - Change Capture and Print

  Responded But No Solution Rengudi 32 views 2 comments 0 points Most recent by User_3ABCE Dec 2, 2022 7:07AMSQL & PL/SQL
• 
  Need to find out the execution time of all the views and stored procedure

  Responded But No Solution Albert Chao 42 views 4 comments 0 points Most recent by Albert Chao Dec 1, 2022 2:57PMSQL & PL/SQL
• 
  How to dynamically pivot on unknown column.

  Solution Accepted User_5F8TP 130 views 9 comments 0 points Most recent by Marwim Dec 1, 2022 12:37PMSQL & PL/SQL
• 
  ELException: java.lang.NullPointerException in ADF Jdeveloper

  Solution Accepted User_BMQ12 15 views 2 comments 0 points Most recent by User_BMQ12 Dec 1, 2022 9:47AMJDeveloper and ADF
• 
  SQLException: Missing IN or OUT parameter at index:: 2

  Solution Accepted User_BMQ12 22 views 2 comments 0 points Most recent by User_BMQ12 Dec 1, 2022 9:29AMJDeveloper and ADF
• 
  how to tell a list of numbers separated by ';' contains a particular number

  Solution Accepted Jian-cdo 40 views 3 comments 0 points Most recent by cormaco Nov 30, 2022 8:17PMSQL & PL/SQL
• 
  Finding TIMESTAMP rows

  Solution Accepted BeefStu 31 views 6 comments 0 points Most recent by mathguy Nov 30, 2022 5:18PMSQL & PL/SQL
• 
  How to covert column names into rows in SQL?

  Responded But No Solution User_CK8A6 70 views 9 comments 0 points Most recent by Frank Kulash Nov 29, 2022 2:55PMSQL & PL/SQL
• 
  Issue with Ordering rows after UNPIVOT columns to rows

  Solution Accepted Roxy rollers 35 views 3 comments 0 points Most recent by Roxy rollers Nov 28, 2022 7:41PMSQL & PL/SQL
• 
  Using a database link in dynamic sql

  Solution Accepted user545194 32 views 2 comments 0 points Most recent by user545194 Nov 28, 2022 11:33AMSQL & PL/SQL
• 
  Select Into VS Cursor

  Solution Accepted Paulo A. Künzel 78 views 6 comments 0 points Most recent by User_3ABCE Nov 28, 2022 5:49AMSQL & PL/SQL
• 
  How can I populate missing values in a balance sheet?

  Solution Accepted User_ZR3PE 88 views 10 comments 0 points Most recent by Frank Kulash Nov 27, 2022 6:28PMSQL & PL/SQL
• 
  Alias a function

  Solution Accepted Pugzly 63 views 6 comments 0 points Most recent by Solomon Yakobson Nov 26, 2022 11:57AMSQL & PL/SQL
• 
  When we should use Scaler subquery and how it works

  Solution Accepted Bikram 77 views 6 comments 0 points Most recent by Solomon Yakobson Nov 26, 2022 11:43AMSQL & PL/SQL
• 
  Need suggestion on developing a real time projects in SQL and PL/SQL only

  Solution Accepted Albert Chao 130 views 7 comments 0 points Most recent by User_U0DGH Nov 26, 2022 7:45AMSQL & PL/SQL
• 
  Oracle SQL Practice Platform

  Solution Accepted Bikram 41 views 3 comments 0 points Most recent by BluShadow Nov 25, 2022 2:12PMSQL & PL/SQL
• 
  SELECT DBMS_METADATA.GET_DDL without storage and constraints

  Responded But No Solution user545194 71 views 4 comments 0 points Most recent by Sven W. Nov 24, 2022 9:13AMSQL & PL/SQL
• 
  Need help with Query

  Responded But No Solution User910243567 72 views 4 comments 0 points Most recent by Frank Kulash Nov 23, 2022 10:26PMSQL & PL/SQL
• 
  ORA_ROWSCN - High Response time - Regarding

  Responded But No Solution Rengudi 56 views 4 comments 0 points Most recent by Rengudi Nov 23, 2022 6:35AMSQL & PL/SQL
• 
  SQL Update command send me "ORA-00903: invalid table name" error

  Responded But No Solution Jean-Baptiste Marotte 53 views 3 comments 0 points Most recent by Jean-Baptiste Marotte Nov 22, 2022 12:49PMSQL & PL/SQL