sql

Discussion List

• 
  Multiple column pivot

  Solution Accepted New Roots 69 views 6 comments 1 point Most recent by New Roots Aug 25, 2022 2:43AMSQL & PL/SQL
• 
  How to check the tables have any relationship or not

  Responded But No Solution User_ULX4X 31 views 2 comments 0 points Most recent by thatJeffSmith-Oracle Aug 24, 2022 12:51PMSQL Developer
• 
  pivot multiple rows (at most 3) into columns

  Solution Accepted Gor_Mahia 71 views 8 comments 0 points Most recent by BluShadow Aug 23, 2022 7:30AMSQL & PL/SQL
• 
  CREATE N NUMBER of rows for a date range

  Solution Accepted BeefStu 91 views 12 comments 0 points Most recent by Solomon Yakobson Aug 22, 2022 2:16PMSQL & PL/SQL
• 
  Order by spend and followed by year

  Solution Accepted Siva ManU 51 views 2 comments 0 points Most recent by Siva ManU Aug 22, 2022 10:11AMSQL Developer
• 
  DIFFERENCE BETWEEN TWO DATE FIELDS IN SECONDS

  Responded But No Solution User_A8YCI 71 views 6 comments 0 points Most recent by User_A8YCI Aug 22, 2022 8:41AMSQL & PL/SQL
• 
  External table - unknown escape sequence

  Solution Accepted user13117585 53 views 7 comments 0 points Most recent by User_3ABCE Aug 22, 2022 5:58AMSQL & PL/SQL
• 
  Highlight sub string in query

  Solution Accepted Gor_Mahia 21 views 3 comments 0 points Most recent by User_3ABCE Aug 22, 2022 5:33AMSQL & PL/SQL
• 
  Convert minutes to hours:minutes

  Solution Accepted Pugzly 79 views 7 comments 0 points Most recent by mathguy Aug 18, 2022 1:07PMSQL & PL/SQL
• 
  transform 2 rows into 1 row

  Solution Accepted Gor_Mahia 41 views 3 comments 0 points Most recent by User_3ABCE Aug 18, 2022 6:23AMSQL & PL/SQL
• 
  Faceted Search

  Responded But No Solution OraDev16 31 views 2 comments 0 points Most recent by OraDev16 Aug 18, 2022 2:03AMAPEX Discussions
• 
  Get unique values from comma separated values

  Responded But No Solution OraDev16 234 views 7 comments 0 points Most recent by mathguy Aug 16, 2022 12:38PMSQL & PL/SQL
• 
  REGEXP_REPLACE leading and trailing whitespace

  Responded But No Solution Rengudi 32 views 2 comments 0 points Most recent by Solomon Yakobson Aug 13, 2022 11:38AMSQL & PL/SQL
• 
  SQL to display missing partition

  Solution Accepted User_B9CRX 42 views 5 comments 0 points Most recent by Jonathan Lewis Aug 12, 2022 4:36PMGeneral Database Discussions
• 
  Fetch 20000 records in each run

  Responded But No Solution Rengudi 52 views 3 comments 0 points Most recent by Rengudi Aug 12, 2022 11:05AMSQL & PL/SQL
• 
  Need to implements logic via query

  Responded But No Solution User_IAP38 41 views 3 comments 0 points Most recent by Stax Aug 12, 2022 7:38AMSwing
• 
  ROW_NUMBER () OVER (PARTITION BY col ORDER BY ROW_NUMBER product value)

  Solution Accepted Rengudi 33 views 3 comments 0 points Most recent by Frank Kulash Aug 11, 2022 4:39PMSQL & PL/SQL
• 
  Getting report error: ORA-01403: no data found when trying to display BLOB column

  Responded But No Solution User_N6QYK 79 views 2 comments 0 points Most recent by User_N6QYK Aug 10, 2022 7:13PMAPEX Discussions
• 
  need to get this result through query

  #Hussain 31 views 1 comment 0 points Most recent by BluShadow Aug 10, 2022 7:14AMSQL & PL/SQL
• 
  Why does CAST work on Apex but not desktop?

  Responded But No Solution User_KGY3D 22 views 2 comments 0 points Most recent by User_KGY3D Aug 9, 2022 4:33PMAPEX Discussions
• 
  Minus in front of field name in where clause???

  Responded But No Solution User_1HH9W 33 views 2 comments 0 points Most recent by Frank Kulash Aug 9, 2022 9:38AMSQL & PL/SQL
• 
  dbms_metadata.get_ddl() gives table definition differently in 19c than 12c

  Responded But No Solution User_AUO6I 31 views 3 comments 0 points Most recent by Solomon Yakobson Aug 8, 2022 4:27PMSQL & PL/SQL
• 
  Regex_replace to ::/

  Solution Accepted Rengudi 51 views 5 comments 0 points Most recent by Frank Kulash Aug 8, 2022 3:23PMSQL & PL/SQL
• 
  ORA-00905: missing keyword in CASE Clause, But I'm able to do with [AND/OR]

  Responded But No Solution User_R5UI6 51 views 8 comments 0 points Most recent by MATTEO RAPPAZZO Aug 8, 2022 1:53PMSQL & PL/SQL
• 
  Employees who were hired on the dow of most employees

  Solution Accepted Pugzly 31 views 4 comments 0 points Most recent by Stax Aug 8, 2022 6:04AMSQL & PL/SQL