sql

Discussion List

• 
  Find Logical Reads cause

  Solution Accepted User_DUYMH 24 views 3 comments 0 points Most recent by mathguy Aug 11, 2021 4:56AMSQL & PL/SQL
• 
  SQL/PL/SQL

  Solution Accepted User_BU3NG 41 views 3 comments 0 points Most recent by Frank Kulash Aug 10, 2021 6:17PMSQL & PL/SQL
• 
  Updating a varray column in table

  Solution Accepted User_DUYMH 101 views 8 comments 0 points Most recent by mathguy Aug 8, 2021 3:39PMSQL & PL/SQL
• 
  Converting a working query to use a subquery

  Solution Accepted BeefStu 21 views 4 comments 0 points Most recent by BeefStu Aug 6, 2021 4:38PMSQL & PL/SQL
• 
  Column with Varchar Data type has date time need to find date time in PST

  Solution Accepted User_51476 31 views 5 comments 0 points Most recent by User_51476 Aug 6, 2021 4:30PMSQL & PL/SQL
• 
  Count of business/working days

  Responded But No Solution User_ZHKQ3 63 views 7 comments 0 points Most recent by Frank Kulash Aug 5, 2021 5:51PMSQL & PL/SQL
• 
  ORA-01017: invalid username/password; logon denied when connecting Oracle19c db from java program

  Responded But No Solution sonu_gupta(ram) 2.6K views 11 comments 0 points Most recent by User_H3J7U Aug 3, 2021 8:34PMSQL & PL/SQL
• 
  How can I access an array in Oracle SQL?

  Responded But No Solution Edisson Gabriel López 31 views 2 comments 0 points Most recent by User_H3J7U Aug 3, 2021 7:52AMSQL & PL/SQL
• 
  Joining 2 Tables and Grouping them based on Fields

  Question User_0V525 11 views 0 comments 0 points Started by User_0V525 Aug 2, 2021 7:17PM SQL Developer
• 
  Porting SQL to PLSQL expecting INTO clause

  Responded But No Solution BeefStu 51 views 7 comments 0 points Most recent by gsalem-Oracle Aug 2, 2021 12:50PMSQL & PL/SQL
• 
  LOB index to be found in user_indexes but not in all_indexes

  Solution Accepted Laury 28 views 2 comments 0 points Most recent by Laury Jul 29, 2021 2:01PMGeneral Database Discussions
• 
  How to check explain plan of a nested table query in SQL Developer or by some query?

  Responded But No Solution Kinjan Bhavsar 21 views 5 comments 0 points Most recent by Jonathan Lewis Jul 29, 2021 1:40PMSQL & PL/SQL
• 
  SQL Developer installing difficulties

  Responded But No Solution User_MDSXN 31 views 3 comments 0 points Most recent by thatJeffSmith-Oracle Jul 27, 2021 4:01PMSQL Developer
• 
  Same SQL_ID and Same FORCE_MATCHING_SIGNATURE

  Solution Accepted Umut Tekin 23 views 2 comments 0 points Most recent by Umut Tekin Jul 27, 2021 2:18PMGeneral Database Discussions
• 
  PLSQL problem creating procedure inconsistent data types

  Solution Accepted BeefStu 81 views 19 comments 0 points Most recent by EdStevens Jul 27, 2021 12:58PMSQL & PL/SQL
• 
  View data

  Responded But No Solution User_HWQS8 22 views 3 comments 0 points Most recent by Billy Verreynne Jul 26, 2021 9:33AMSQL & PL/SQL
• 
  Silver DBAの問題について

  Question User_R1DS6 1 view 0 comments 0 points Started by User_R1DS6 Jul 25, 2021 5:27AM Oracle Database Express Edition (XE)
• 
  Error "ORA-12704: character set mismatch" in CASE Statement

  Solution Accepted Edisson Gabriel López 237 views 3 comments 0 points Most recent by mathguy Jul 24, 2021 2:52PMSQL & PL/SQL
• 
  Using grouping sets to accumulate values

  Solution Accepted BeefStu 22 views 2 comments 0 points Most recent by BeefStu Jul 23, 2021 7:46PMSQL & PL/SQL
• 
  Holiday Count between dates

  Responded But No Solution Newuser1 21 views 2 comments 0 points Most recent by mathguy Jul 23, 2021 2:42PMSQL & PL/SQL
• 
  Oracle looking for conservative dates with lead and lag

  Solution Accepted BeefStu 71 views 18 comments 0 points Most recent by BeefStu Jul 23, 2021 12:59PMSQL & PL/SQL
• 
  How to check explain plan of a nested table query?

  Solution Accepted Kinjan Bhavsar 45 views 12 comments 0 points Most recent by Kinjan Bhavsar Jul 21, 2021 8:44AMSQL & PL/SQL
• 
  Need sql query of this requirements

  jaijeeva 41 views 3 comments 0 points Most recent by Billy Verreynne Jul 20, 2021 8:28AMSQL & PL/SQL
• 
  How can I compare two tables in a CASE ?

  Solution Accepted Edisson Gabriel López 31 views 9 comments 0 points Most recent by Edisson Gabriel López Jul 19, 2021 10:01PMSQL & PL/SQL