SQL Query to find gaps in date ranges

Author: asktom.oracle.com | Published: 8th Nov 2007 | Visited: 81 times | Add Comment
Filed in: Oracle FAQ

Hi Tom, I have a problem that I would like to solve using pure SQL and not PL/SQL (if possible). I suspect that there may be an Analytic solution to the problem, but have not been able to work it out for myself thus far. I have a table with th...

Read Article

Sponsored Links

• Sql query Sir, I have joined this team having severe problems with SQL and found one having excessive CpU from AWR reports. There are many changes that we have suggested to this insert, could you please give your valuable inputs also please. On a 10G i ...

• Query string encryption for ASP.NET Clear text query strings are a potential security threat for your web application. Thus, query strings should be always encryp ...

• Localizing Date and Time Display in ASP.NET Localizing date and time display to meet the user's preferred lang ...

• Use encoded query string with ASP.NET In order to improve the security of ASP.NET web applications, query strings should be always encryp ...

• Query Hi Tom, I definetly remember seeing something similar to this on this site, but could not find. If I am right, could you direct me to the link please? Thank you, Sinan here is my question. <code> -- Create table create table ASKTOM_TA ...

• Convert Query Result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report This utility is used for convert query result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report, supported SQL Server and ODBC connect ...

• date field in many to many relationships Hi Tom, Good morning. While resolving many-many relationships, we create an intersection table and we create a FK for the other two table Primary keys. But if the PK tables have date fields in them i.e. hire date,create date etc, do we need t ...

• How to query miniport driver information (802.11 OIDs) using DeviceIOControl() function? Query 802.11 OIDs using DeviceIOControl from a .NET-C# applica ...

• Find royalty-free images fast with Adobe Stock Photos Search all your favorite stock providers at once with Adobe Stock Photos in Adobe Bridge. Watch the movie for an overview, and follow the companion Adobe PDF tutorial for step-by-step instruct ...

• How to Create Date Calendar as User Control How to Create a User Control for Start Date and End Date Valida ...

Next: multiple databases in a single RAC cluster