Generate a range of dates using SQL

by

There’s no need to use extra large tables or ALL_OBJECTS table:

SELECT TRUNC (SYSDATE - ROWNUM) dt
  FROM DUAL CONNECT BY ROWNUM < 366

will do the trick.

More Related Contents:

  1. How to create id with AUTO_INCREMENT on Oracle?
  2. LISTAGG in Oracle to return distinct values
  3. Fetch the row which has the Max value for a column
  4. Oracle SQL: Update a table with data from another table
  5. Oracle SQL – How to Retrieve highest 5 values of a column [duplicate]
  6. Fetch the rows which have the Max value for a column for each distinct value of another column
  7. Concatenate and group multiple rows in Oracle [duplicate]
  8. Difference between BYTE and CHAR in column datatypes
  9. SQL to generate a list of numbers from 1 to 100
  10. SQL Error: ORA-00933: SQL command not properly ended
  11. CASE vs. DECODE
  12. DATEDIFF function in Oracle [duplicate]
  13. Pivoting of data using two columns
  14. Check if current date is between two dates Oracle SQL
  15. Benefits Of Using SQL Ordinal Position Notation?
  16. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  17. Unordered results in SQL
  18. Oracle Dynamic Pivoting
  19. Foreign Key Creation issue in Oracle
  20. create custom function for date difference excluding weekends and holidays in oracle sql
  21. What is it exactly a BLOB in a DBMS context
  22. Custom Order in Oracle SQL
  23. Compare Strings ignoring accents in SQL (ORACLE)
  24. How do you interpret a query’s explain plan?
  25. Oracle DB: How can I write query ignoring case?
  26. ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
  27. How to call Oracle MD5 hash function?
  28. Oracle Convert TIMESTAMP with Timezone to DATE
  29. SQL Server equivalent of WM_CONCAT function [duplicate]
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment