I’m using Oracle 12c. I need to generate dates for the start and end of weeks which begin on Thursday and end the following Wednesday. An example of the output I’d like is – I have the following SQL to generate the Start Date(s) – SELECT startdate FROM (SELECT next_day(date ‘2020-03-12’ – 1, ‘Thursday’) +… Read More Multiple columns from DUAL?