Friday the 13th generator

SQL> @ fri13.sql
SQL> set pagesize 100
SQL> set linesize 200
SQL> set trimspool on
SQL> set echo on
SQL> col d format a40
SQL>
SQL> select
  2  regexp_replace(
  3  to_char( dt, 'Day "the" Ddth, Month yyyy' )
  4  ,'  *', ' ') d
  5  from
  6  (
  7  select to_date ( '19800104','yyyymmdd') + level * 7 dt
  8  from dual connect by level < ( 2018 - 1980 ) * 52
  9  )
 10  where to_char( dt, 'dd') = '13'
 11  order by dt;

D
----------------------------------------
Friday the 13th, June 1980
Friday the 13th, February 1981
Friday the 13th, March 1981
Friday the 13th, November 1981
Friday the 13th, August 1982
Friday the 13th, May 1983
Friday the 13th, January 1984
Friday the 13th, April 1984
Friday the 13th, July 1984
Friday the 13th, September 1985
Friday the 13th, December 1985
Friday the 13th, June 1986
Friday the 13th, February 1987
Friday the 13th, March 1987
Friday the 13th, November 1987
Friday the 13th, May 1988
Friday the 13th, January 1989
Friday the 13th, October 1989
Friday the 13th, April 1990
Friday the 13th, July 1990
Friday the 13th, September 1991
Friday the 13th, December 1991
Friday the 13th, March 1992
Friday the 13th, November 1992
Friday the 13th, August 1993
Friday the 13th, May 1994
Friday the 13th, January 1995
Friday the 13th, October 1995
Friday the 13th, September 1996
Friday the 13th, December 1996
Friday the 13th, June 1997
Friday the 13th, February 1998
Friday the 13th, March 1998
Friday the 13th, November 1998
Friday the 13th, August 1999
Friday the 13th, October 2000
Friday the 13th, April 2001
Friday the 13th, July 2001
Friday the 13th, September 2002
Friday the 13th, December 2002
Friday the 13th, June 2003
Friday the 13th, February 2004
Friday the 13th, August 2004
Friday the 13th, May 2005
Friday the 13th, January 2006
Friday the 13th, October 2006
Friday the 13th, April 2007
Friday the 13th, July 2007
Friday the 13th, June 2008
Friday the 13th, February 2009
Friday the 13th, March 2009
Friday the 13th, November 2009
Friday the 13th, August 2010
Friday the 13th, May 2011
Friday the 13th, January 2012
Friday the 13th, April 2012
Friday the 13th, July 2012
Friday the 13th, September 2013
Friday the 13th, December 2013
Friday the 13th, June 2014
Friday the 13th, February 2015
Friday the 13th, March 2015
Friday the 13th, November 2015
Friday the 13th, May 2016
Friday the 13th, January 2017
Friday the 13th, October 2017

66 rows selected.