Generating dates between two dates

by 
select 
  A.ID, 
  A.START_DATE+delta dt
from 
  t_dates A, 
  (
     select level-1 as delta 
     from dual 
     connect by level-1 <= (
       select max(end_date - start_date) from t_dates
     )
  )
where A.START_DATE+delta <= A.end_date
order by 1, 2

More Related Contents:

  1. Calculating difference between two timestamps in Oracle in milliseconds
  2. How to use Timestamp_to_scn and Scn_to_timestamp in Oracle?
  3. How do I limit the number of rows returned by an Oracle query after ordering?
  4. How to create id with AUTO_INCREMENT on Oracle?
  5. When do I need to use a semicolon vs a slash in Oracle SQL?
  6. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  7. How to handle a single quote in Oracle SQL
  8. Select count(*) from multiple tables
  9. Fetch the rows which have the Max value for a column for each distinct value of another column
  10. REGEX to select nth value from a list, allowing for nulls
  11. Concatenate and group multiple rows in Oracle [duplicate]
  12. Difference between BYTE and CHAR in column datatypes
  13. Call a stored procedure with another in Oracle
  14. create table with sequence.nextval in oracle [duplicate]
  15. Oracle: loading a large xml file?
  16. IF EXISTS condition not working with PLSQL
  17. Group by alias (Oracle)
  18. Using pivot on multiple columns of an Oracle row
  19. Sleep function in ORACLE
  20. Split comma separated values of a column in row, through Oracle SQL query
  21. Foreign Key Creation issue in Oracle
  22. create custom function for date difference excluding weekends and holidays in oracle sql
  23. How do I list all tables in a schema in Oracle SQL?
  24. Is there a version control system for database structure changes?
  25. oracle sql: update if exists else insert [duplicate]
  26. Oracle: Updating a table column using ROWNUM in conjunction with ORDER BY clause
  27. Compare Strings ignoring accents in SQL (ORACLE)
  28. Oracle DB: How can I write query ignoring case?
  29. ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
  30. Oracle Convert TIMESTAMP with Timezone to DATE

Leave a Comment