Search notes:

Oracle SQL MODEL clause example: Date generator

Generate a series of 100 consecutive dates, starting with today:
select
   dt
from (
   select
      trunc(sysdate) dt
   from
      dual
)
model 
  dimension by (0 d)
  measures     (dt )
  rules iterate(100)
  (
    dt[ iteration_number+1 ] = dt[ iteration_number ]+1
  );

See also

Oracle SQL: Generate (an arbitrary amount of) rows/data
The model clause.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1745357432, '13.59.147.113', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/select/model/examples/date-generator(54): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78