sql pl sql

Discussion List

• 
  priority update in oracle

  Responded But No Solution User_KVV1C 687 views 21 comments 5 points Most recent by User_KVV1C Nov 27, 2019 7:41AMSQL & PL/SQL
• 
  How to Bring one particular SQL to AWR report

  Solution Accepted Raj Aru 205 views 5 comments 4 points Most recent by Raj Aru Nov 27, 2019 4:44AMGeneral Database Discussions
• 
  onClick how to get Entry Form in Edit or Insert Mode.

  Responded But No Solution AQH 115 views 1 comment 0 points Most recent by AQH Oct 31, 2019 10:27AMAPEX Discussions
• 
  Data based on Date conditions issue

  Responded But No Solution 4102954 102 views 7 comments 0 points Most recent by mathguy Oct 6, 2019 10:39PMSQL & PL/SQL
• 
  SQL

  Responded But No Solution User_LCHKL 313 views 12 comments 2 points Most recent by Jonathan Lewis Oct 5, 2019 3:06AMSQL & PL/SQL
• 
  How to display default value if sql not return any row.

  Solution Accepted Vemula Muni 3.4K views 3 comments 2 points Most recent by jaramill Sep 13, 2019 1:09PMSQL & PL/SQL
• 
  Getting ORA-00920: invalid relational operator For Merge Statement

  Solution Accepted Vemula Muni 204 views 2 comments 0 points Most recent by mNem Sep 9, 2019 7:41AMSQL & PL/SQL
• 
  Do not include in the LoV the car numbers already used in the second table

  Responded But No Solution AndriiPrincip 64 views 2 comments 0 points Most recent by Pavel_p Sep 8, 2019 1:31AMAPEX Discussions
• 
  Need to update Week end day flag

  Solution Accepted Vemula Muni 137 views 5 comments 1 point Most recent by mathguy Aug 30, 2019 2:01AMSQL & PL/SQL
• 
  Sequence Cache reset in 12c

  Solution Accepted Shamed H 1.3K views 9 comments 2 points Most recent by Shamed H Aug 29, 2019 7:33AMSQL & PL/SQL
• 
  Golden Bean has improved Performance on Oracle tables

  Responded But No Solution Rama_G 231 views 19 comments 5 points Most recent by Mike Kutz Aug 28, 2019 4:38PMSQL & PL/SQL
• 
  Find the date gaps and count

  Solution Accepted New Roots 300 views 6 comments 2 points Most recent by New Roots Aug 27, 2019 9:21AMSQL & PL/SQL
• 
  ora-01407 cannot update to null

  Solution Accepted Vemula Muni 761 views 9 comments 0 points Most recent by L. Fernigrini Aug 27, 2019 8:37AMSQL & PL/SQL
• 
  Need to alter Update Query

  Solution Accepted Vemula Muni 265 views 13 comments 0 points Most recent by Frank Kulash Aug 26, 2019 8:36PMSQL & PL/SQL
• 
  Maintaining SQL Code: Lexicals Are Used, How to decipher?

  Responded But No Solution Bob Paris 155 views 6 comments 2 points Most recent by Glen Conway Aug 21, 2019 3:28PMSQL Developer
• 
  how to remove trailing white spaces in columns while using Spool

  Responded But No Solution 4068702 904 views 12 comments 1 point Most recent by [Deleted User] Aug 21, 2019 7:48AMSQL & PL/SQL
• 
  Cumulative sum and Lag Scenario

  Responded But No Solution Mr.Jondee 1.4K views 28 comments 2 points Most recent by Mr.Jondee Aug 14, 2019 9:51PMSQL & PL/SQL
• 
  Fetching Data Effective date wise by joining three tables

  Solution Accepted Vemula Muni 677 views 14 comments 0 points Most recent by mathguy Aug 14, 2019 12:11PMSQL & PL/SQL
• 
  Need to alter existing query to fetch correct data.

  Solution Accepted Vemula Muni 339 views 17 comments 0 points Most recent by Frank Kulash Aug 13, 2019 9:41AMSQL & PL/SQL
• 
  Concatenate specific rows with analytical function/plsql

  Solution Accepted Sandy0594 99 views 5 comments 2 points Most recent by Frank Kulash Aug 8, 2019 4:11PMSQL & PL/SQL
• 
  Fetching Contract Employee information by Join the JOB_DTL,JOB_DTL1,IQN_BU Tables.

  Solution Accepted Vemula Muni 406 views 12 comments 2 points Most recent by Vemula Muni Aug 4, 2019 7:23AMSQL & PL/SQL
• 
  Why won't this PL/SQL function compile?

  Responded But No Solution 3988598 939 views 14 comments 0 points Most recent by L. Fernigrini Jul 31, 2019 1:15PMSQL & PL/SQL
• 
  Sequence number in oracle SQL SQL

  Solution Accepted Vemula Muni 516 views 14 comments 2 points Most recent by mathguy Jul 31, 2019 10:52AMSQL & PL/SQL
• 
  How do I continually add a pl/sql return value to the last recorded value in a table?

  Responded But No Solution 3988598 93 views 2 comments 0 points Most recent by 3988598 Jul 29, 2019 7:18AMSQL & PL/SQL