sql

Discussion List

• 
  Miss Punch in Information Query

  Solution Accepted M.bro 83 views 5 comments 0 points Most recent by Frank Kulash Nov 21, 2022 11:50AMSQL & PL/SQL
• 
  How to identify correlated subquery and what is the replacement of it

  Solution Accepted Bikram 53 views 3 comments 0 points Most recent by Bikram Nov 21, 2022 4:12AMSQL & PL/SQL
• 
  Trying to convert multiple rows for a given id to a json table

  Responded But No Solution Brian___B 163 views 17 comments 0 points Most recent by Brian___B Nov 18, 2022 6:23PMGeneral Database Discussions
• 
  Extract scripts using VS Code

  Responded But No Solution Paulo A. Künzel 53 views 2 comments 0 points Most recent by thatJeffSmith-Oracle Nov 18, 2022 4:30PMSQL & PL/SQL
• 
  Need to have sequence number for rows based on a custom logic.

  Responded But No Solution User_XY6RS 81 views 9 comments 0 points Most recent by mathguy Nov 18, 2022 3:05PMSQL & PL/SQL
• 
  How can I make a conditional report in Oracle APEX?

  Responded But No Solution Edisson Gabriel López 142 views 2 comments 0 points Most recent by User_8LEFJ Nov 18, 2022 7:02AMAPEX Discussions
• 
  Generate Dynamic WHERE clause condition

  Solution Accepted Rengudi 75 views 4 comments 0 points Most recent by Frank Kulash Nov 17, 2022 9:48PMSQL & PL/SQL
• 
  Adding grants to a role

  Responded But No Solution user545194 153 views 17 comments 0 points Most recent by user545194 Nov 17, 2022 10:20AMSQL & PL/SQL
• 
  Sync check with primary

  Solution Accepted Rengudi 67 views 4 comments 0 points Most recent by Rengudi Nov 17, 2022 7:53AMSQL & PL/SQL
• 
  How to get a record count for each file in a table?

  Solution Accepted User_DIL60 181 views 17 comments 0 points Most recent by User_DIL60 Nov 16, 2022 9:52PMSQL & PL/SQL
• 
  How to prepare Hierarchical Tree (Table) to JSON for D3-Charts

  Responded But No Solution Jegor Wieler 43 views 4 comments 0 points Most recent by Jegor Wieler Nov 16, 2022 2:34PMSQL & PL/SQL
• 
  Adding sum of certain rows and cols to my query

  Responded But No Solution User_BY2GE 21 views 3 comments 0 points Most recent by Solomon Yakobson Nov 15, 2022 1:29PMGeneral Database Discussions
• 
  How can I use a subquery in conjunction with recursive subquery factoring?

  Solution Accepted Pseudo Nym 43 views 4 comments 0 points Most recent by BluShadow Nov 11, 2022 12:05PMSQL & PL/SQL
• 
  Interactive Grid takes long time to load

  Responded But No Solution gkthomas 62 views 5 comments 0 points Most recent by InoL Nov 10, 2022 5:01PMAPEX Discussions
• 
  Average salary for each department

  Solution Accepted Pugzly 54 views 3 comments 0 points Most recent by mathguy Nov 10, 2022 2:28PMSQL & PL/SQL
• 
  Return grouped records without a specific line type

  Solution Accepted 20161212 42 views 3 comments 0 points Most recent by Mohamed Houri Nov 9, 2022 3:54PMSQL & PL/SQL
• 
  IW parameter not returning start of week and not able to handle logical expression using CASE

  Responded But No Solution Albert Chao 33 views 2 comments 0 points Most recent by Frank Kulash Nov 9, 2022 1:22PMSQL & PL/SQL
• 
  converting rows to columns

  Responded But No Solution Bommi 83 views 7 comments 0 points Most recent by Bommi Nov 9, 2022 12:26PMSQL & PL/SQL
• 
  Pivot - Grand total

  Solution Accepted Rengudi 65 views 5 comments 0 points Most recent by Stax Nov 8, 2022 2:15PMSQL & PL/SQL
• 
  If Table names changed will it affect DB link?

  Solution Accepted kalyan vedagiri 41 views 3 comments 0 points Most recent by mathguy Nov 8, 2022 6:39AMSQL & PL/SQL
• 
  Sorting by a specific column, but not include that on Grouping

  Solution Accepted User_QDHXF 53 views 3 comments 0 points Most recent by User_WVSC7 Nov 6, 2022 5:53PMSQL & PL/SQL
• 
  sqlcl lb data: how to overwrite existing data.xml

  Question Robert__H 11 views 1 comment 0 points Most recent by wes_fdny Nov 4, 2022 3:39PMSQLcl
• 
  Group rows in 5 minute intervals

  Solution Accepted BeefStu 171 views 15 comments 0 points Most recent by mathguy Nov 2, 2022 5:57PMSQL & PL/SQL
• 
  JSON Framing using BULK COLLECT

  Solution Accepted User_HH9X5 70 views 9 comments 0 points Most recent by User_HH9X5 Nov 2, 2022 5:22AMGeneral Database Discussions