sql

Discussion List

• 
  Which one give better performance ? either Scalar sub query or Left outer join?

  Kannan Sekar 31 views 3 comments 0 points Most recent by mathguy January 29SQL & PL/SQL
• 
  ROW-00014: Cannot update row as the data in the database has changed

  Responded But No Solution User_ETQ5A 56 views 4 comments 0 points Most recent by User_ETQ5A January 29SQL Developer
• 
  Getting unique records daily currency rates

  Responded But No Solution User_SQSR4 11 views 2 comments 0 points Most recent by mathguy January 28SQL & PL/SQL
• 
  insert multiple rows on table based on other table's column value

  Solution Accepted user8629294 21 views 6 comments 0 points Most recent by Frank Kulash January 25SQL & PL/SQL
• 
  Views dropped

  Solution Accepted user545194 31 views 10 comments 0 points Most recent by user545194 January 25General Database Discussions
• 
  Apex AB: Extract value of Number-Field and use the value as condition for another query

  Responded But No Solution User_UN2PH 11 views 1 comment 0 points Most recent by AndyH January 23APEX Discussions
• 
  Is there a way to avoid corrupted indexes after running SQL Loader?

  Responded But No Solution simon87 11 views 1 comment 0 points Most recent by L. Fernigrini January 21SQL & PL/SQL
• 
  Delta load logic using oracle merge/delete sql statement

  Solution Accepted user12251389 91 views 23 comments 0 points Most recent by Solomon Yakobson January 20SQL & PL/SQL
• 
  Follow-up to getting a summation from results

  Solution Accepted User_OMEF8 71 views 18 comments 0 points Most recent by Frank Kulash January 16SQL & PL/SQL
• 
  How to handle repeated records in SQL?

  Solution Accepted RajeshKota 51 views 4 comments 0 points Most recent by Frank Kulash January 16SQL & PL/SQL
• 
  How A Query Executes in Oracle

  sandeepgupta_18 21 views 1 comment 0 points Most recent by Frank Kulash January 15SQL & PL/SQL
• 
  I have requirement that entire column values are null want to adjust as per expected format

  Solution Accepted User_TIFB4 41 views 4 comments 0 points Most recent by User_TIFB4 January 14SQL & PL/SQL
• 
  Reg expression

  Responded But No Solution Closed User_76ZL9 21 views 1 comment 0 points Most recent by Solomon Yakobson January 13SQL & PL/SQL
• 
  SQL to give Friday of running week

  Solution Accepted karthick.raje 41 views 5 comments 0 points Most recent by RogerT January 13SQL & PL/SQL
• 
  COUNT(*) KEEP (DENSE_RANK LAST ORDER BY COUNT(*)) OVER (PARTITION BY A,B)

  Solution Accepted Martin J. 31 views 1 comment 0 points Most recent by Martin J. January 11SQL & PL/SQL
• 
  Getting a summation of results

  Solution Accepted User_OMEF8 61 views 10 comments 0 points Most recent by User_OMEF8 January 9SQL & PL/SQL
• 
  Getting a summation of results -- Please delete this discussion/question.

  User_OMEF8 21 views 0 comments 0 points Started by User_OMEF8 January 8 Reports
• 
  Need to tune performance issue of a sql query

  Responded But No Solution Yogendra Singh 61 views 6 comments 0 points Most recent by evgenyg January 5SQL Developer
• 
  group by value count and other count to show

  Responded But No Solution User_7PZDE 21 views 2 comments 0 points Most recent by Frank Kulash December 2020SQL & PL/SQL
• 
  Select not null columns from a table

  Responded But No Solution Soofi 51 views 7 comments 0 points Most recent by jflack December 2020SQL & PL/SQL
• 
  how does the where clause work here?

  Solution Accepted User_68DIP 21 views 4 comments 0 points Most recent by Frank Kulash December 2020SQL & PL/SQL
• 
  What's the problem with my password while installing Apex 20.1?

  Responded But No Solution User_UBZRD 51 views 4 comments 0 points Most recent by Aredd December 2020APEX Discussions
• 
  select result without same rows

  Responded But No Solution User_48J1W 31 views 1 comment 0 points Most recent by Frank Kulash December 2020SQL & PL/SQL
• 
  TRUNCATE TABLE giving error even with DROP ANY TABLE system privilege

  Responded But No Solution sabyakgp 41 views 5 comments 0 points Most recent by Brett Calhoun December 2020General Database Discussions