pl

Discussion List

• 
  Trigger

  Responded But No Solution 415ece1e-3bed-441a-898c-93950f9c712f 172 views 2 comments 1 point Most recent by L. Fernigrini Dec 19, 2019 7:22AMEspañol Discusiones
• 
  What is wrong with this PL/SQL code, and how to debug it in Apex?

  Solution Accepted Closed DannyS-Oracle 413 views 10 comments 5 points Most recent by TexasApexDeveloper Aug 5, 2016 12:30PMAPEX Discussions
• 
  Does Oracle provides caching for Corelated Sub-queries?

  Responded But No Solution Closed user8492264 1.3K views 9 comments 3 points Most recent by AndrewSayer Jun 14, 2016 2:39PMSQL & PL/SQL
• 
  Generating multiple rows of fixed length output for each record

  Responded But No Solution Closed 3244859 571 views 3 comments 0 points Most recent by 3244859 Jun 13, 2016 1:15PMSQL & PL/SQL
• 
  count rows into two different variables

  Responded But No Solution Closed 3068783 262 views 4 comments 1 point Most recent by Lothar Flatz Dec 28, 2015 10:07AMSQL & PL/SQL
• 
  INTO clause inside a FOR loop's SELECT query

  Responded But No Solution Closed Boobal Ganesan 878 views 14 comments 1 point Most recent by John Spencer Aug 13, 2015 9:01AMSQL & PL/SQL
• 
  How to optimize performance of this SQL query

  Solution Accepted Closed Gayathri Venugopal 93 views 3 comments 1 point Most recent by BluShadow Jul 6, 2015 5:18AMSQL & PL/SQL
• 
  Aggregate function -Avg is not working in my sql query

  Responded But No Solution Closed Gayathri Venugopal 543 views 4 comments 2 points Most recent by John Stegeman Jun 30, 2015 7:56AMSQL & PL/SQL
• 
  Function return issue

  Responded But No Solution Closed 2943907 167 views 11 comments 2 points Most recent by Billy Verreynne May 6, 2015 4:52AMSQL & PL/SQL
• 
  Table partitioning

  Responded But No Solution Closed simon87 1K views 4 comments 2 points Most recent by Billy Verreynne Jan 6, 2015 3:28AMSQL & PL/SQL
• 
  Updating multiple rows with calculated values (distance by Pythagorean theorem)

  Responded But No Solution Closed 1ddb0fc1-fc76-4548-a8f5-708fc37d36a1 1.1K views 3 comments 0 points Most recent by Unknown Dec 11, 2014 9:18PMSQL & PL/SQL
• 
  Issue While Updating a Table periodically. Incremental Update on only updated records from Source ta

  Responded But No Solution Closed 1223504 2.9K views 13 comments 0 points Most recent by Biju Das Sep 8, 2014 1:10PMSQL & PL/SQL
• 
  While Loop Error

  Responded But No Solution Closed 187babb6-aec4-4bc2-900f-d731a81d9d8c 49 views 3 comments 0 points Most recent by Frank Kulash Aug 6, 2014 6:02PMSQL & PL/SQL
• 
  Inserting, deleting and updating in one to one, one to many and many to many relationship

  Responded But No Solution Closed 2712919 1.8K views 7 comments 0 points Most recent by Unknown Jul 14, 2014 6:03PMSQL & PL/SQL
• 
  Copy data from external table

  Responded But No Solution Closed user8786417 91 views 4 comments 0 points Most recent by BluShadow Jun 24, 2014 10:36AMSQL & PL/SQL
• 
  Help with a trigger

  Responded But No Solution Closed 2641697 1.7K views 4 comments 3 points Most recent by SomeoneElse Jun 23, 2014 8:46PMSQL & PL/SQL
• 
  Spool truncating

  Responded But No Solution Closed bobnash251 1.3K views 2 comments 0 points Most recent by BluShadow Jun 19, 2014 6:32AMSQL & PL/SQL
• 
  Handling exceptions. ORA-06550.

  Responded But No Solution Closed 2652078 3.1K views 6 comments 0 points Most recent by 2652078 Jun 12, 2014 3:13PMSQL & PL/SQL
• 
  Literature on PL/SQL testing

  Responded But No Solution Closed user2081233 183 views 8 comments 0 points Most recent by Sven W. Jun 4, 2014 9:29AMSQL & PL/SQL
• 
  Having problems returning multiple rows with parameterised CURSOR and IF, ELSE DBMS_OUPUT

  Solution Accepted Closed 2652078 1.5K views 3 comments 0 points Most recent by 2652078 May 23, 2014 9:36AMSQL & PL/SQL
• 
  SQL Developer log has no source/message

  Responded But No Solution Closed User_K2AC3 1.5K views 3 comments 0 points Most recent by Jim Smith May 23, 2014 2:20AMSQL Developer
• 
  Copying from SQL Developer Worksheet doesn't retain formatting (font,color etc...)in Microsoft Word

  Question Closed 2678062 2 views 0 comments 0 points Started by 2678062 May 21, 2014 3:15PM SQL & PL/SQL
• 
  Reading XML from Long Datatype

  Responded But No Solution Closed 2677588 306 views 3 comments 0 points Most recent by odie_63 May 21, 2014 7:40AMSQL & PL/SQL