sql

Discussion List

• 
  Index Organized Table (IOT)

  Responded But No Solution SHAJ_SHAJIN 31 views 1 comment 0 points Most recent by Solomon Yakobson Dec 14, 2022 3:38AMSQL & PL/SQL
• 
  Facing issue in Lexical Parameter while customizing AR Invoice Print Standard report in Oracle?

  Responded But No Solution User_8VXM0 21 views 1 comment 0 points Most recent by FrankGordon Dec 13, 2022 5:26PMSQL Developer Data Modeler Discussions
• 
  Group uninterrupted days for min Balance?

  Solution Accepted User_ZR3PE 61 views 7 comments 0 points Most recent by BluShadow Dec 13, 2022 8:51AMSQL & PL/SQL
• 
  How to retrieve the current month data from Oracle SQL?

  Responded But No Solution Venkatesh K J 21 views 1 comment 0 points Most recent by Solomon Yakobson Dec 12, 2022 5:30PMDatabase 19c-21c
• 
  Need to convert date time to cst timezone

  Responded But No Solution User_X9S6M 61 views 10 comments 0 points Most recent by mathguy Dec 12, 2022 5:28PMSQL & PL/SQL
• 
  View optimization with CASE in WHERE clause

  Solution Accepted User_77G7L 61 views 2 comments 0 points Most recent by User_77G7L Dec 8, 2022 2:17AMSQL & PL/SQL
• 
  Need to form the rows into columns using below data source

  Responded But No Solution User_IT7WJ 31 views 2 comments 0 points Most recent by User_IT7WJ Dec 8, 2022 1:47AMSQL & PL/SQL
• 
  compare two columns and print only the difference

  Solution Accepted Rengudi 121 views 9 comments 0 points Most recent by Paulzip Dec 7, 2022 3:02PMSQL & PL/SQL
• 
  Adding privileges to a role

  Solution Accepted user545194 21 views 2 comments 0 points Most recent by user545194 Dec 7, 2022 8:22AMGeneral Database Discussions
• 
  Dynamic WHERE clause

  Responded But No Solution Spike House 71 views 1 comment 0 points Most recent by User_3ABCE Dec 7, 2022 7:39AMSQL & PL/SQL
• 
  Need some solution over Synonyms

  Responded But No Solution SHAJ_SHAJIN 41 views 3 comments 0 points Most recent by Paulzip Dec 7, 2022 12:43AMSQL & PL/SQL
• 
  Generating TIMESTAMPs without fraction

  Solution Accepted Pugzly 111 views 12 comments 0 points Most recent by Pugzly Dec 6, 2022 7:40PMSQL & PL/SQL
• 
  SQL * PLUS FORMAT

  Solution Accepted Rengudi 61 views 6 comments 0 points Most recent by Solomon Yakobson Dec 5, 2022 8:38PMSQL & PL/SQL
• 
  Create table with a CLOB column and default value of {} (Oracle 19c)

  Solution Accepted John Walker 141 views 9 comments 0 points Most recent by User_3ABCE Dec 5, 2022 8:31PMSQL & PL/SQL
• 
  ORA-01843 not a valid month when trying to use Case Statements

  Responded But No Solution User_MXQR1 91 views 9 comments 0 points Most recent by Frank Kulash Dec 5, 2022 4:01PMSQL & PL/SQL
• 
  sql loader passing dynamic values issue

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

  Solution Accepted Rengudi 61 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 31 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 131 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 171 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 21 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 51 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 41 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