sql

Discussion List

• 
  INSERT DUMMY RECORDS if NO RECORD PRESENT

  Responded But No Solution User_7C1YX 83 views 6 comments 0 points Most recent by mathguy Jan 27, 2023 1:52AMSQL & PL/SQL
• 
  Need help with Tunning - Recursive with clause

  Responded But No Solution User_J6BYR 63 views 8 comments 0 points Most recent by Frank Kulash Jan 26, 2023 8:47PMSQL & PL/SQL
• 
  Merge Source table error -ORA-30926:

  Responded But No Solution Rengudi 48 views 6 comments 0 points Most recent by mathguy Jan 25, 2023 7:12PMSQL & PL/SQL
• 
  LEFT JOIN WITH 2 KEYS

  Responded But No Solution Bjornlaat 72 views 4 comments 0 points Most recent by Stax Jan 25, 2023 4:23PMSQL & PL/SQL
• 
  Combing grouping set queries into one

  Solution Accepted Pugzly 49 views 7 comments 0 points Most recent by mathguy Jan 24, 2023 2:53PMSQL & PL/SQL
• 
  Split Provided Date Range into Quarter

  Responded But No Solution User_KO3DG 58 views 6 comments 0 points Most recent by Solomon Yakobson Jan 24, 2023 1:56AMSQL & PL/SQL
• 
  Extracting value from a column with the Brackets

  Responded But No Solution User_L2DX1 54 views 4 comments 0 points Most recent by mathguy Jan 23, 2023 10:59PMSQL & PL/SQL
• 
  Request for SQL Query for below requirement

  Solution Accepted User_MAWAL 134 views 15 comments 0 points Most recent by Frank Kulash Jan 23, 2023 10:06AMSQL & PL/SQL
• 
  how to check history (list sql queries) from specific date/time range?

  Responded But No Solution User_DLMOO 32 views 1 comment 0 points Most recent by Saubhik Jan 20, 2023 8:58AMSQL & PL/SQL
• 
  Windowing different data sets and generate BATCH Numbers

  Solution Accepted 816802 63 views 3 comments 0 points Most recent by 816802 Jan 19, 2023 6:46PMSQL & PL/SQL
• 
  How can i get performance feedback responses comments as a query?

  Question User_1MRQR 6 views 0 comments 0 points Started by User_1MRQR Jan 19, 2023 8:50AM Multilingual Engine
• 
  Create URL that authenticates with JWT.

  Responded But No Solution Paulo A. Künzel 21 views 2 comments 0 points Most recent by Paulo A. Künzel Jan 18, 2023 11:43AMAPEX Discussions
• 
  Left join with 2 parameters

  Question Bjornlaat 71 views 4 comments 0 points Most recent by Frank Kulash Jan 18, 2023 11:18AMSQL & PL/SQL
• 
  Append in nested array JSON object in oracle

  Responded But No Solution User_RT71S 61 views 2 comments 0 points Most recent by Solomon Yakobson Jan 17, 2023 9:04PMSQL & PL/SQL
• 
  ROLLUP by week, customer_id

  Solution Accepted Pugzly 66 views 8 comments 0 points Most recent by mathguy Jan 17, 2023 8:16PMSQL & PL/SQL
• 
  how to make faster retrieve by joining two tables having 1 billion rows each?

  Responded But No Solution iGeni 116 views 7 comments 0 points Most recent by BluShadow Jan 17, 2023 12:29PMSQL & PL/SQL
• 
  SQL aggregate table query

  Solution Accepted user13047999 101 views 8 comments 0 points Most recent by user13047999 Jan 16, 2023 7:08PMSQL & PL/SQL
• 
  How to select only one value if there are two distinct values per person?

  Solution Accepted User_5F8TP 44 views 3 comments 0 points Most recent by User_5F8TP Jan 16, 2023 5:52PMSQL & PL/SQL
• 
  display duplicates only

  Solution Accepted Bjornlaat 126 views 15 comments 0 points Most recent by Bjornlaat Jan 16, 2023 12:14PMSQL & PL/SQL
• 
  find all customers who have no purchases in 30 days or none at all.

  Solution Accepted Pugzly 42 views 3 comments 0 points Most recent by mathguy Jan 16, 2023 6:19AMSQL & PL/SQL
• 
  Rolling 30 day PERIOD to check purchases

  Responded But No Solution BeefStu 41 views 5 comments 0 points Most recent by Solomon Yakobson Jan 15, 2023 6:36PMSQL & PL/SQL
• 
  Display products for each category

  Solution Accepted Pugzly 32 views 1 comment 0 points Most recent by Solomon Yakobson Jan 12, 2023 8:52PMSQL & PL/SQL
• 
  21.5.0 Bug in Semicolon Comment Handing with ODP.NET?

  Solution Accepted User_MYJN6 19 views 1 comment 0 points Most recent by Christian.Shay -Oracle Jan 12, 2023 6:45PMOracle Developer Tools for VS Code
• 
  How to put a whole select query into a variable and call that variable inside another select query

  Responded But No Solution User_QUQ9A 161 views 12 comments 0 points Most recent by Frank Kulash Jan 12, 2023 4:43PMSQL & PL/SQL