sql pl sql

Discussion List

• 
  Count of a node in xml

  Solution Accepted User_KEHP1 483 views 2 comments 1 point Most recent by A.JOSH Oct 4, 2021 12:58PMPL/SQL XML Programming
• 
  Help needed in writing the SQL

  Responded But No Solution 4057554 182 views 10 comments 2 points Most recent by Lokesh A Nov 23, 2020 1:58PMSQL & PL/SQL
• 
  Wrong Space - Is these syntax supported in oracle?

  Responded But No Solution RameshSagar 95 views 5 comments 0 points Most recent by Frank Kulash Sep 15, 2020 12:27PMSQL & PL/SQL
• 
  SQL Query to get the product and ingredients and the ingredients of the ingredients

  Responded But No Solution User_02F0C 1.1K views 12 comments 3 points Most recent by User_02F0C Sep 5, 2020 3:17AMSQL & PL/SQL
• 
  Sql Query to find increment of a number using select Statement

  Responded But No Solution User_40B57 8K views 7 comments 2 points Most recent by Solomon Yakobson Sep 4, 2020 6:00AMSQL & PL/SQL
• 
  How to build cursor based on values / parameters in given string

  Solution Accepted LukSkyWalker 68 views 3 comments 3 points Most recent by LukSkyWalker Aug 20, 2020 9:48AMAPEX Discussions
• 
  pivot/unpivot under certain condition

  Solution Accepted elmasduro 103 views 2 comments 1 point Most recent by Frank Kulash Aug 7, 2020 5:15PMSQL & PL/SQL
• 
  Query tuning

  Responded But No Solution DBApps 53 views 3 comments 0 points Most recent by evgenyg Aug 6, 2020 7:47PMGeneral Database Discussions
• 
  How to create Primary key on partitioned column.

  Solution Accepted user1362938 1.2K views 6 comments 1 point Most recent by Jonathan Lewis Jul 17, 2020 10:42AMSQL & PL/SQL
• 
  eliminating repeating amounts while joining

  Solution Accepted elmasduro 56 views 1 comment 0 points Most recent by Frank Kulash Jul 14, 2020 8:21PMSQL & PL/SQL
• 
  Sorting the data set

  Solution Accepted 2652054 77 views 8 comments 1 point Most recent by L. Fernigrini Jul 11, 2020 11:01AMSQL & PL/SQL
• 
  Best way for data archiving

  Responded But No Solution 4135353 102 views 9 comments 3 points Most recent by EdStevens Jul 8, 2020 10:00AMSQL & PL/SQL
• 
  Load using External table fails in 18c

  Solution Accepted User_KEHP1 71 views 3 comments 3 points Most recent by odie_63 Jul 3, 2020 5:08AMSQL & PL/SQL
• 
  Dynamic sql in procedure for inserting

  Solution Accepted Rafal S 163 views 11 comments 2 points Most recent by KayK Jul 2, 2020 6:40AMSQL & PL/SQL
• 
  Search and replace in Clob column

  Solution Accepted User_DUYMH 7.6K views 14 comments 2 points Most recent by Mark D Powell Jun 17, 2020 9:55AMSQL & PL/SQL
• 
  convert clob to long varchar

  Responded But No Solution User_AC3QE 902 views 6 comments 0 points Most recent by Tubby Jun 15, 2020 5:06PMSQL & PL/SQL
• 
  Operation on a Table type variable storing multiple values one time rather than looping

  Responded But No Solution 4245323 578 views 19 comments 1 point Most recent by John Thorton May 30, 2020 7:44PMSQL & PL/SQL
• 
  timezone conversion

  Responded But No Solution Vicky007 93 views 6 comments 1 point Most recent by cormaco May 29, 2020 7:33AMSQL & PL/SQL
• 
  avg of all emp count

  Solution Accepted User_7PZDE 84 views 8 comments 0 points Most recent by User_7PZDE May 28, 2020 7:06AMSQL & PL/SQL
• 
  Display parent and child records sequentially

  Solution Accepted Marco Foxx 286 views 4 comments 1 point Most recent by InoL May 21, 2020 10:38PMAPEX Discussions
• 
  SQLLDR : Loading decimal file record in Number column

  Responded But No Solution Vicky007 53 views 4 comments 0 points Most recent by cormaco May 15, 2020 7:25AMSQL & PL/SQL
• 
  Oracle wallet with PL/SQ

  Responded But No Solution Ivan Ruiz 36 views 1 comment 0 points Most recent by Tubby May 14, 2020 1:29PMSQL & PL/SQL
• 
  SQLLDR : using TRIM on COMMENT column

  Solution Accepted Vicky007 75 views 3 comments 1 point Most recent by odie_63 May 14, 2020 5:45AMSQL & PL/SQL
• 
  NULL - Table Records Fetch - HZ_CONTACT_POINTS

  Solution Accepted User_FHYJ0 727 views 18 comments 4 points Most recent by Paulzip May 4, 2020 9:05AMSQL & PL/SQL
• 
  Issue with timestamp and date comparison

  Solution Accepted Vicky007 1.4K views 8 comments 1 point Most recent by Wyche414 Apr 27, 2020 9:16AMSQL & PL/SQL