sql

Discussion List

• 
  ORA-00905: missing keyword in CASE Clause, But I'm able to do with [AND/OR]

  Responded But No Solution User_R5UI6 29 views 7 comments 0 points Most recent by Frank Kulash Aug 5, 2022 10:24AMSQL & PL/SQL
• 
  When to use scaler subquery

  Responded But No Solution Bikram 21 views 3 comments 0 points Most recent by Sven W. Aug 5, 2022 10:07AMSQL & PL/SQL
• 
  Yes/No Column based on multiple criterias

  Solution Accepted DaBears3579 33 views 5 comments 0 points Most recent by Stax Aug 5, 2022 6:02AMSQL & PL/SQL
• 
  TABLE CREATION

  Responded But No Solution Shahab Mohyeuddin 30 views 1 comment 0 points Most recent by L. Fernigrini Aug 4, 2022 3:58PMSQL Developer
• 
  Oracle 19c SE2 - Performance Views

  Responded But No Solution user545194 12 views 1 comment 0 points Most recent by AJ Aug 4, 2022 10:14AMGeneral Database Discussions
• 
  Inserting R or Y value in a shipment stop depending on location refnum

  Solution Accepted Rob Mengelers 44 views 8 comments 0 points Most recent by Frank Kulash Aug 3, 2022 1:23PMSQL & PL/SQL
• 
  Pl/sql to check if the record exits already in the table , if yes then find the max salary ?

  Solution Accepted AS08 47 views 5 comments 0 points Most recent by Frank Kulash Aug 2, 2022 11:11PMSQL & PL/SQL
• 
  Search exact word in a sentence without using CONTAINS operator

  Solution Accepted OraDev16 54 views 4 comments 0 points Most recent by Frank Kulash Aug 2, 2022 5:18PMSQL & PL/SQL
• 
  IDENTIFY UNIQUE ROW IN TABLE WHILE USING PIVOT AND GROUP BY

  Responded But No Solution User_N31VH 24 views 2 comments 0 points Most recent by Stax Aug 2, 2022 5:50AMSQL & PL/SQL
• 
  Newbie question , what the symbols means

  Responded But No Solution User_ULX4X 75 views 9 comments 0 points Most recent by BluShadow Aug 1, 2022 7:40AMSQL & PL/SQL
• 
  Merge or other?

  Responded But No Solution User_2TTDA 17 views 1 comment 0 points Most recent by Solomon Yakobson Jul 31, 2022 11:23PMSQL & PL/SQL
• 
  Get the earliest date for a customer order

  Solution Accepted User_G3NSO 20 views 4 comments 0 points Most recent by Solomon Yakobson Jul 31, 2022 4:40PMSQL & PL/SQL
• 
  How to use insert with update?

  Responded But No Solution User_2TTDA 32 views 2 comments 0 points Most recent by Frank Kulash Jul 31, 2022 3:08AMSQL & PL/SQL
• 
  DB2 SQL to Oracle SQL change

  Responded But No Solution User_49B97 19 views 3 comments 0 points Most recent by Frank Kulash Jul 30, 2022 8:14PMSQL & PL/SQL
• 
  delegation query based on levels

  Responded But No Solution Gor_Mahia 10 views 1 comment 0 points Most recent by Frank Kulash Jul 30, 2022 10:29AMSQL & PL/SQL
• 
  Reorganize storage structure

  Solution Accepted ProDBA 11 views 3 comments 0 points Most recent by ProDBA Jul 28, 2022 7:15AMGeneral Database Discussions
• 
  Nested Dynamic JSON in PL/SQL

  Solution Accepted Rithu Raj 41 views 3 comments 0 points Most recent by Rithu Raj Jul 27, 2022 12:16PMSQL & PL/SQL
• 
  CSV column comparison to single value column - SQL query

  Solution Accepted Rengudi 35 views 4 comments 0 points Most recent by BluShadow Jul 27, 2022 11:11AMSQL & PL/SQL
• 
  How to insert output of a table function into a table using a procedure (read qn for detailed exp)

  Responded But No Solution karthick_senthilnathan 31 views 3 comments 0 points Most recent by BluShadow Jul 26, 2022 2:49PMSQL & PL/SQL
• 
  pivoting data

  Solution Accepted Devx 31 views 3 comments 0 points Most recent by Frank Kulash Jul 22, 2022 4:12PMSQL & PL/SQL
• 
  columnar encryption support when oracle DB is not owned (SaaS license)

  Question Roman Havrylyak 11 views 0 comments 0 points Started by Roman Havrylyak Jul 22, 2022 12:50PM General Database Discussions
• 
  sqlcl lb data: how to overwrite existing data.xml

  Question Robert__H 4 views 0 comments 0 points Started by Robert__H Jul 22, 2022 11:38AM SQLcl
• 
  Parse Dynamic Nested Json in Oracle APEX

  Question Rithu Raj 27 views 0 comments 0 points Started by Rithu Raj Jul 21, 2022 1:48PM SQL & PL/SQL