pl_sql

Discussion List

• 
  New to PL SQL and need help for an update cursor and 2 tables

  Responded But No Solution User_C5G2Y 31 views 4 comments 0 points Most recent by BluShadow Jun 21, 2021 8:17AMSQL & PL/SQL
• 
  get data in report

  Solution Accepted User_AC3QE 31 views 11 comments 0 points Most recent by User_AC3QE Jun 18, 2021 8:27PMSQL & PL/SQL
• 
  Need Day wise leave statistic report

  Solution Accepted Shaik_Muhammad 21 views 7 comments 0 points Most recent by Shaik_Muhammad Jun 8, 2021 7:23AMGeneral Database Discussions
• 
  sql query to perform SUM on String data type

  Responded But No Solution User_X9S6M 984 views 1 comment 0 points Most recent by Frank Kulash Jun 7, 2021 1:30PMSQL & PL/SQL
• 
  Passing LISTAGG values into Incluase

  Solution Accepted User_BU3NG 31 views 2 comments 0 points Most recent by BluShadow Jun 7, 2021 11:16AMSQL & PL/SQL
• 
  How to find out the grants which has been provided to a table ? what is the syntax ?

  Responded But No Solution User_M9IF5 25 views 1 comment 0 points Most recent by BEDE Jun 4, 2021 7:23AMSQL & PL/SQL
• 
  Problem with a trigger calling a procedure

  Solution Accepted User_KC6Y3 53 views 8 comments 0 points Most recent by User_KC6Y3 Jun 3, 2021 4:20PMSQL & PL/SQL
• 
  SQL Logic for using LIKE condition based First keyword of a column value with another table

  Responded But No Solution Rama0830 21 views 4 comments 0 points Most recent by User_H3J7U Jun 2, 2021 7:39AMSQL & PL/SQL
• 
  pivot row to column from multiple groups

  Solution Accepted Nicks123 51 views 10 comments 0 points Most recent by Nicks123 Jun 1, 2021 9:53PMSQL & PL/SQL
• 
  sql query to display Distinct Months

  Responded But No Solution User_X9S6M 21 views 2 comments 0 points Most recent by Frank Kulash May 31, 2021 4:47PMSQL & PL/SQL
• 
  Conversion of multi-valued string in to columns and rows

  Solution Accepted Pavankumar Sudabattula-Oracle 65 views 13 comments 0 points Most recent by Solomon Yakobson May 25, 2021 8:09PMSQL & PL/SQL
• 
  grouping and summing sub queries to get grand sum

  Solution Accepted Gor_Mahia 31 views 5 comments 0 points Most recent by mathguy May 24, 2021 11:09PMSQL & PL/SQL
• 
  Question relative to optimisation

  Responded But No Solution Stephane Baribeau 11 views 1 comment 0 points Most recent by Paulzip May 21, 2021 6:11PMSQL & PL/SQL
• 
  Oracle Order by SQL Query running longer time

  Responded But No Solution User_AAHZI 41 views 3 comments 0 points Most recent by mathguy May 21, 2021 2:28PMSQL & PL/SQL
• 
  How I write a triggers to prevent deletion a particular record related to salary of an employee?

  Responded But No Solution User_IS1G6 21 views 5 comments 0 points Most recent by User_IS1G6 May 21, 2021 11:10AMSQL & PL/SQL
• 
  Received ORA-06502: PL/SQL: numeric or value error: raw variable length too long

  Solution Accepted sect55 221 views 3 comments 0 points Most recent by Paulzip May 18, 2021 4:12PMSQL & PL/SQL
• 
  Compare concatenated string with current timestamp

  Solution Accepted LukSkyWalker 43 views 3 comments 0 points Most recent by LukSkyWalker May 18, 2021 11:10AMSQL & PL/SQL
• 
  Oracle Apex How to use Function returning sql query in IG

  Responded But No Solution Vinipanda 748 views 4 comments 0 points Most recent by Billy Verreynne May 17, 2021 1:17PMSQL & PL/SQL
• 
  apex_application.G_F01 no longer working in 21.1.0

  Solution Accepted Geert01 66 views 5 comments 0 points Most recent by Geert01 May 16, 2021 3:12PMAPEX Discussions
• 
  Oracle Data Miner functionality/ Machine Learning/ Data Mining

  Responded But No Solution User_PUHRJ 71 views 3 comments 0 points Most recent by User_PUHRJ May 14, 2021 6:51PMSQL Developer
• 
  Oracle Apex Modfiy Grid query to fetch previous quarter data if current not available

  Responded But No Solution Vinipanda 2 views 1 comment 0 points Most recent by Christian Pitet May 12, 2021 12:47PMAPEX Discussions
• 
  Combination that leads to an error: Illegal use of a type before its declaration

  Solution Accepted user5935717 148 views 19 comments 0 points Most recent by BluShadow May 11, 2021 7:34AMSQL & PL/SQL
• 
  Create Compound Trigger to Make View Editable

  Question User_9VHGT 11 views 0 comments 0 points Started by User_9VHGT May 7, 2021 7:59PM General Database Discussions
• 
  Combination that leads to an error: Illegal use of a type before its declaration

  Responded But No Solution user5935717 13 views 2 comments 0 points Most recent by user5935717 May 7, 2021 5:23AMODP.NET